I have used the NZ functionin a query eg. (y2005: Nz([2005],"0"))to place a
zero in any records that do not have data, however the records that do now
return a number in text format rather than the original currency format.
How do I have the result stay in currency format?

I have a field called *StreetName* which has the complete street name.
This includes: the number (like 1500), the prefix (like N), the actual
name (like Main), and sometimes two words that are ALSO the name like
(Betty Ford), and then the suffix (like Blvd.).  One other thing, there

An application I need to export to requires that each record in the query I
run have a unique ID field.  This would be accomplished in a table via use of
the autoincrement field type, but I'm not sure how to create a new field of
in my query to provide the same function.

got a question about using pivot tables in Access.
You know how in Excel you can have the "data" fields in a pivot table
either top-to-bottom (the default) or side-by-side? I'm trying to figure
out how to do that in Access. When I add them to the data field I can

Simple question, how do I fiilter out values that dont have a contactID but
show up in my query. Also how do I get the query to show the associated field
values rather than the number values stored in the fields in a contact table,
stored from a combo box choice on a form?

I was wondering if you could help me:
I have one large table for my addresses. It looks like this:
Name    Land phone    Mobile    phone    Office phone
Andrew    1111111        222222222    3333333333

I have a query in which I want to able to enter a week ending date, and
the query will then return results for that whole week. e.g. if I enter
in 15/7 it will give me everything from 9/7 to 15/7.
I entered "Between [Enter W/E Date] And ([Enter W/E Date]-6)" in the

I am using a SQL count(*) to count blank items under certain conditions.  
When I clear a field manually in Access the newly blank fields are not
counted.  The SQL statement looks like:
SELECT count(*) as rec_count FROM January where Problem_Owner = 'andmart'

A field "enc_timestamp" contains the date and time a record is created.  I
know how to get all records between day X and Y, but how can I also specify a
time criteria, i.e. between day X and Y and between time A and B?  I want to
figure out how many records are being generated on ...

Hi. I'm a new Access user.
I'm trying to calculate time difference in minutes between differen
dates. For example, difference in minutes between 6/12/05 15:36 an
6/15/05 00:14.

im doing this in my query  Sum(IIf([SFBIS1]=0,1,0))    this works and say if
the field is equal to zero put a one otherwise 0          is there a way to
say if the field is a 0 or a 2 or a 5 then put a one otherwise 0    how would
i do this?

I need to truncated the content of a Memo field, but the Left,Right
Mid functions come up with an error message that a comma (,) cannot b
used.
Also I would like to select which line of the text in the Memo field i

NOOB HERE
I was wondering if there was a way to replace a multiple numbers with one
universal number.  Lets say these are phone numbers without the dashes...
Example:

Can I use case statement within an Access query?
I have a data item PCPCajCd1 that may contain a value of "FED", "H&W" and/or
"SMI"  When it contains "FED", I want to subtotal the corresponding numeric
data within data item PCPCajAm1 as FED_Sum.

I would like a query to list all the 3 field combinations available from 6
fields per data row (date), then union them or such like to create a query to
list all the 3 field combinations drawn to date. From this i should be able
to do the same for a 4 field combination of the ...