I am stumped!  I have a query that uses a function to calculate the
total freight for each order.
curTotFreight = Nz(DSum("[Freight]", "tblFreightBill", _
       "[POKey]= " & lngPOKey & " AND [FreightBillStatus] = 'A'"), 0)

I have a database of events booked at three halls.
I'm trying to design a query that will return a list of Saturdays when
each hall is NOT booked.
What criteria should I use for the Date?

If I place a querry in a form, can I update entries in the querry as
displsyed the from and have the data tables update as well?

When tested without making the table my make table query returns numbers in
the correct percentage format but in the 'made' table they appear as
decimals.
With the 'made table' being deleted and replaced how can I make the figures

New XP computer, installed my Microsoft Access 2000, imported my Access data
base,
Microsoft Access imported good, Microsoft Visual Basic fell to the wayside,
ERROR:

This seems like it should be really simple....I'm still learning Access and
can't quite get it.  I've searched for the process, but those I've found all
seem slightly different.
I've simply got a table with a few 100 records.

I want to insert a comma after [City] in the address string in my query.  
Expr1: [City] & " " & [State] & "  " & [ZipCode].  HELP!

Hi, I am using the following IIF statement to calculate the percentage
difference between a Selling Price and a Order Selling Price, bearing
in mind you cannot deivide by zero!
OrdvsSell: IIf([SellingPrice]=0,"NO

The following to function statements work as calculated form controls but not
in any type of query that I have tried.
DLookUp("[DLA]![One]","DLA","[Dline]=[Caselog]![deadline]")
(DLookUp("[DLB]![Value]","DLB","[PlanD1]=[Dline]"))-(DLookUp("[DLB]![Value]","DLB","[ActD1]=[Dline]"))

We have a MS Access database that pulls information from our JD Edward SQL
Database. There is a query that list all trucks and what product was last
loaded in them last.  We had to add a special tax to everything we sell.  
This tax is set up like an product. So now when we pull ...

I want to pull up records for dates between January and March. How do I
do that? I don't want the year, just by months. Thanks in advance.

I have a field in a query called NextReview, and currently another
field
NextReviewYear: Year([Next Review]) with the criteria Year(Now()).  I
need this criteria to find all dates for the current year, before the

I would like to select rows from a table where a text date field is greater
than 60 days before the current date.  Can you help with the expression ?  
Thx.

I am using MS Access 2003.  My application has a form with a command button
on it that will "lock" a record from further updating--turns a bit variable
on.  Below  are the command button basics:
Private Sub cmdLockCustomer_Click()

how can i show the month and year out of the current date
1/2/2006     i just want to see   1/2006