I don't have much experience writing SQL queries and am having a hard
time getting my head around this one.  I am hoping that someone with
more experience will find this an easy exercise.
I have 3 tables, tblAccounts, tblOrders, and tblQuotes.

I hope I can explain this correctly.  I have a query that has a Date Entered
field.  The criteria for date entered is [date], so that when you run the
query you will be prompted for the date.  That works.  I created a macro to
call the query, export to a text file, then print a ...

Using Access 2000.
Okay, sometimes I'll write a query that has date parameters, something like
"select * from table where [process_date] between [select start date] and
[select end date]"

I am working with a time field in a table and would like to confirm the way
in which I am calculating average time of day.  The time field records the
time of patient discharge.
Can I obtain the average time of discharge for a given interval (day, week,

im working with some data using access 2000,
in this i have a field of phone numbers which are a bit of a mess,
is there a way in that i can change 01 234 123456 to 01234 123456 quicky and
easily

I have two quaries. I export these two quaries (Using File>>Export) into
comma deliminated text files for achiving. How can I append these two text
files automatically.
Thank you

Using ACC2000.
The more I think about this, the more I think it can't be done, but I'll ask
anyway.
I have a bunch of queries that need to be updated, which requires adding

I'm new at Access.  I need to take a copy of a query I have for a test run.  
How do I make a copy to take with me for them to use?

I have created an update query against a table using the following in the
Update field:
dbo_INVPRICE!SellingPrice+(dbo_INVPRICE!SellingPrice*0.035)
Currently the result will have 5 decimals, and I need to ensure it only has

I want to write a query or use vba to combine a field from multiple records
into one records summarized by one field with the second field holding all
the variations separated by commas.  For example, if data was:
Field 1   Field2

If I have a table with varibles in ie TAX, DISCOUNT1, DISCOUNT2 etc, can I
call these in an unrelated query?
say
SellingPrice*[TAX]/100 ?

It's me again. Thanks now for your help.
I am trying to create a query which will allow us to determine the
number of filings during a specified period of time (usually monthly).
I would like to be able to view a summary by investigator and group

I have a simple parameter query that returns the sales orders for a
particular sales area when promted, how can I get the query to return all
orders for all areas if the return key is pressed at the parameter prompt??
Thanks

How can I check if the third decimal of a number is 0?  I know it can't be as
hard as I am making it - maybe I have Access burn-out?
I am checking (in a query) a field with only five digits two numbers with
three decimal places.  If the number does not have a zero in that position ...

I need a bit of help with this one. It should be rather simple, however, I'm
stuck! writers block, i guess! How do I format this:
IIf(IsNull([Num_Btl_Grss_Wt_Oz]),Null,CDbl([Num_Btl_Grss_Wt_Oz])) to be fixed
with a 0 - 3 decimal space output?