removing blank fields in a query
I need to build a table using a old database. the field I want has some data
in them but can also have blanks. I do not wan the fields with blanks how do
I accomplish this.
>>I do not wan the fields with blanks
Just omit that field.
Or do you not want records that have blank fields?
Use criteria of Is Not Null on the field.
Build a little - Test a little
> I need to build a table using a old database. the field I want has some data
> in them but can also have blanks. I do not wan the fields with blanks how ...Linking a Column List to a Row List #2
Thanks for the help, it worked perfectly
Moe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1250
View this thread: http://www.excelforum.com/showthread.php?threadid=27428
...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Excel
When using auto-filtering, how can I "number" how many records are displayed.
Your question has fallen into an Access news group. Try an Excel news group
for a better chance at getting a quick answer.
Microsoft Access MVP
> When using auto-filtering, how can I "number" how many records are displayed.
"Rachel" <Rachel@discussions.microsoft.com> 在郵件
> When using auto-filtering, how can I "number" how many records are
...Alternate Row Shading
I'm a newbie who's got a five-column worksheet and about 900 rows, most of
them already typed. Grateful if someone could advise how to shade all of
the rows in an alternate fashion, i.e., light-gray, then dark-gray, etc.
> I'm a newbie who's got a five-column worksheet and about 900 rows,
> most of them already typed. Grateful if someone could advise how to
> shade all of the rows in an alternate fashion, i.e., light-gray, then
> dark-...How To Copy Rows without Work Art
I have some Word Art in say Rows 9-23, I use some Macro code to copy cells
9-23 down to 10 grouped rows below 23, but everytime I run the Macro it also
copies a 'New' Work Art over the existing Art below Row 15. My fear is that
my file size will balloon. My code simply states
How can I copy Rows 9-23 without the WorkArt also (which is 'floating' over
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...PO's printing Blank
When a user creates a PO and prints to screen they are
coming up blank Please Help
What happens when they print to printer? Does the printer prints a blank
"Edward Perrier" <firstname.lastname@example.org> wrote in message
> When a user creates a PO and prints to screen they are
> coming up blank Please Help
Are they completely blank, or are the lines missing. If it is just the
lines, it could be the release dates?
"Edward Perrier" <email@example.com> wrote in...empty rows at bottom of worksheet
My worksheet has about 66,000 empty rows at the bottom of the sheet and that
affects my usage of the scrollbar on the right of the screen. Anyone know how
i can get rid of those miscellaneous rows?
If you will turn on the page break preview (piece of paper with a magnifying
glass) which is the icon on the on the Standard Toolbar to the right of the
Printer icon it will show you exactly what is going to print. There are
solid blue lines that the edge of the page, the dashed blue lines are soft
page breaks. Find the solid blue line at the bottom of the spreadsheet and
drag it ...blank business cards from printer
I can print preview the cards I created but paper comes out blank. printed
test page and other documents. Printer goes thru the motions but no ink.
using publisher 2003.
Is the content of the card an image rather than a mix of images and text? If the
card content is a picture, be sure you have "Print full-resolution linked
graphics" enabled. (Advanced Print Settings in the print dialogue).
Are you using a template from the built-in templates that are part of the
Publisher program? Special Paper Business cards will not print the built-in
images. These cards have to be purch...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hfirstname.lastname@example.org> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...GETPIVOTDATA and (blank)
I have created a spreadsheet which has two pivot tables in it on separate
sheets. In addition there is a summary sheet which I use the GETPIVOTDATA
function to extract data from the pivot tables referencing adjacent cells for
the Manager and Rep ID's. The original data includes some rows without ID's
in either the Rep or the Manager fields resulting in some "(blank)" entries
on both pivot tables. Where this has happened on the first table I have
entered "(blank)" in my reference cell on the summary sheet and the data is
extracted as nomal.
When I...blank cd cover designs
Looking for some cool cd cover designs for all types of music
"OL' MUSIC LOVER" <OL' MUSIC LOVER@discussions.microsoft.com> wrote in
> Looking for some cool cd cover designs for all types of music
Google it. I don't want to...
Mary Sauer MSFT MVP
"OL' MUSIC LOVER" <OL' MUSIC LOVER@discussions.microsoft.com> wrote in me...Empty rows
When I do Shift+Page Down+End+Arrow Down from the first selected row, it goes
to row 65,536. How do I get it to go to the end of the report (the last
clear your used range first:
"Connie Martin" <Connie Martin@discussions.microsoft.com> schrieb im
> When I do Shift+Page Down+End+Arrow Down from the first selected row,
> to row 65,536. How do I get it to go to the end of the re...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Visio Viewer 2003 shows blank pages in Internet Explorer 6
When opening a Visio .vsd file created with Visio 2002 or 2003 using
Explorer -> right mouse button -> open with -> Internet Explorer, I
get a blank page.
Already tried the following but nothing helped:
* Uninstall/Reinstall of Visio 2003 Viewer
* Repair of Visio 2003 Viewer
* Install of Visio 2007 Viewer
Visio Professional 2003 is also installed on my pc, but I don't know
which was installed first: Visio or the Viewer.
But the problem appears also on pcs without Visio Pro. Currently we
have no other option than to advise our user...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Text wrap does not expand row height automatically.
Cell/row height only shows one line, even if the automatic row is chosen.
What seems to be the problem? Help.
Make sure the cells that should cause expanded heights are formated to wrap.
"Frank R" wrote:
> Cell/row height only shows one line, even if the automatic row is chosen.
> What seems to be the problem? Help.
You must set Wrap Text and Row Autofit.
BUT.........if you have any merged cells they will not respond to row
Either get rid of them or you will need VBA code to deal with them.
See google search thread f...Max number of consectutive blanks in a range
I have this formula in column G
In Column H, I like to count the maximum number of consecutive blanks in
that entire range.
Meaning, there may 5 consective blanks, then 3, then 18, then 7. I'd like 18
to be returned.
In H1 enter1
In H2 enter:
=IF(G2="",H1+1,0) and copy down
In another cell the answer is:
Gary''s Student - gsnu201001
> I have this formula in col...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <email@example.com> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...How do you insert page numbers larger than 1000?
I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
Hi mregen (firstname.lastname@example.org),
in the newsgroups
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...Select alternate rows to copy
I would like to select alternate rows within a range on a worksheet to copy
to another sheet. Any ideas on how to do this?
Use a spare column (I used B but any will do), enter this formula and copy
down to the full extent of your data. You will get alternating TRUE, FALSE
Now invoke an autofilter (Data>Filter>Autofilter) and filter on which one
you want. Copy that data and pate to another sheet.
Microsoft MVP - Excel