MS Access has "assisted" me to create the following query, that provide the
output I'm looking for as long as click through paramenter inputs for
"Sched_Uptime" and "Outage_Mins_Used" with no input. The problem is that I
didn't intentonally build parameters into the query.  I am new ...

These three functions, Format, Left, and Right, are built-in functions. Why I
can't use them in building expressions. The error message is "Undefined
Format function is in query". Need help here!
Many thanks in advance for any help!

Okay, here's the situation.  I was getting no value on my expression for
averaging 52 separate fields.  With the help of everyone here, I figured out
the problem.  If one of the fields in the equation is null, it won't perform
the query.

im trying to do a slect query.  i want to see how many loans were done each
month for each year.  see below
county     from 7/1/04 to 7/31/04       from 8/1/04 to 8/31/04
Adam               5                                            6

I have an excel file that has city, state and zip in one field.  Is it
possible to separate them in Access, and if so, how?
Thank you

I need to set up a query that will give me a result set that lists results on
multiple rows depending on the value of a field [row#]
ex.  If [row#] is 3, then I need the other information that I am running the
query for to show up 3 times on different rows in the results.

I have a query that returns MeetingDates. I am trying to create a column
that shows the week number of the month. (1-5) for these dates.  Any ideas??

I have Access 2003 and have an Access 2000 database running in it and my
queries are printing out incorrectly. Although dificult to explain, I'll
try... The row height is such that all rows are the same size, but about 1/3
down the page, the text starts moving up towards the top ...

I am trying to make a variable that reflects the date of the previous
Wednesday relative to the current date.  Is there a way I can do this?
Thank you for your help.

ok on my form i have a field where i enter the quantity of a certain item
being bought.  i want it to update the "in stock" field from my submenu2
table by subtracting out the number in the quantity box, i need it to only
update for the item that is selected in the drop box next ...

Windows XP Professional
Office 2000
I have a table where shipment activity is posted.  If a shipment is held
by US Customs, there are up to 5 different reasons as to why.  Only

Hi. I'm selecting records using a date range criteria in a query and I want
the Year part to based on a field in a table. So if the value of
PlacementStartYear in tblSECPlacementStartYear is currently 2004, I want the
criteria to select all values that fall between 1st Sept 2004 ...

    Is there any tool to achieve reocrd locking in MS Access.
Thanks,
Swapna.

I am trying to create a query from two tables and another query. I got the
following error message:
"You have chosen fields from record sources which the wizard cannot connect.
You may have chosen fields from a table and from a query based on that table.

I am working in Access 2002.  I want to create a query that will select every
fifth record from a table.  I want to use this query to populate a list box.  
I understand the "Sort" part of this process.  What I can't figure out is
what to put in the "Criteria" box when I am ...