I have a report which in which I'm grouping my fields by result. There are a
number of check boxes which may apply to each grouping. I want a group
footer which will tally the number of responses checked.
So far I've come up with this expression:

The following query is taking about 70 seconds to run on my fast local PC.
I expected it to take 5 or 10 seconds at most.  The two join fields are
indexed and each of the fields used in the criteria are indexed.  The two
fields in the Order By are also indexed.  tblDetail ...

This seems like such a simple thing... that I just can't figure out why I
can't get it!
I need to make a query that displays the value from a combo box from a form
as one of the fields in the Select statement.  I tried using the same format

I am having a mental block as to how to return just 1 instance of records
from the INVESTIGATOR table.  Each investigator may have many projects, that
is captured in a JOINING table using the relationshipID.  The JOINING table
is my middle table of a Many-to-Many Relationship ...

I've got a client with an Access 2003 database.   He had a network problem,
and one record got corrupted.
I can see the record if I create a query that searches for it by a unique
Job id:

I have a form where the user can enter from 1 to 4 different criteria in text
boxes.  The text boxes are: ReceiptNum, Date, BuyerName, Staff.  What I'm
trying to accopmplish is to run a query based on that criteria.  What I want,
for example, is if I'm looking for a record of all ...

I have a query that has a WHERE clause that checks for values IN, and
I pass it a list of values, like so:
WHERE Table.Fld08 IN ("Value1", "Value2", ...)
Because of a recent change in those values, I thought it best to

I currently use an Excel worksheet function that allows me to take a value,
write an IF statement against that value that outputs a new value using the
ceiling/floor MS Excel worksheet function.  IF(CEILING(#val,500) - #val)>390,
FLOOR(#val,500), CEILING(#val,500))  Basically, if ...

I have a multi-table database the maintains repair records. There are
multiple records in TBLService for each record in TBLEquip.
I want to query these two tables to pull out only the most recent service
record (date) for each piece of equipment.

My table has a amount field which contains Credits and debits. I have another
field which has two values C for Credit and D for Debit.
I would like to sum up both credits and debits into two different fields.
How can I accomplish that? Thanks.

I have two queries Q1 and Q2 which have a common ID field.
I want to get the records of Q1 except those where the ID
exists in Q2.
Is there a way to do this?

I have attempted to use the second function here:
http://www.mvps.org/access/datetime/date0006.htm
________________________________________________________________
Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer

I would like to create a parameter query that prompts the user to enter a
year and then a month and pull the data from a table that has a date field
called "Counseling Date" formatted using Medium Date.  I can get it to work
by creating a parameter query asking for beginning and ...

I am new to Ms access, would like to know how to replace fields with some
specific values, i.e. want to replace all records with a field named MONTH
by "May".
What should I do?  Thanks.

i have two columns on a query,..receipts and disbursements,,both in currency
type..is there any expression that i can use to compute for the running
balances for every entry on either fields like say:
Rcpt....Dis....RunningBal