I have a database that uses the count function to count how many actions have
been done.  If no actions have been done is there a way to get it to return
the value of 0 instead of just not displaying the data that it tries to count.

Hey all,
teaching myself access and have a question about a certain query:
The following is the SQL although I created the query in design view, can
anybody point me in a direction of getting this query to show data as of now

I am writing a report where the user specifies the beginning date and I go
get the information for the twelve month period that begins with that date.
Once I have the data I need to get a sum of hours worked for the month for
each employee.

Access 2000.  I have several laptops which employees enter data in the field
(Out of the office).  The data is copied to floppy disks once a week for the
previous week (Sun through Sat), and returned to the office.  The floppy
disks are appended to the tables on the main db in ...

I have a master table and a details table.
Both tables have fields (id, name)
I need a query to list id & names from the master table where the details
records are equal. For example:

Hi - I have written a very simple database which includes a query with a
reference to a field on a subform.  When I run the query on my computer it
works fine.  When I run it on my client's computer, it returns no records.  I
am using version 11.6355.6360 SP1.  The client has 11 ...

I am merging two tables in a query.  Table A contains all products and Table
B contains only products with a warranty.  I want a listing of all products
regardless of whether it is in the warranty table or not.
Thank you for your help,

I have a query that pulls up records by date entered. The date is stored in
the date/time  format. Is there a function or a way of changing the date
simply date without the time.
The data is captured through a barcode reader into the database as a

Using A2K.  tblAgencyAssistance looks like this:
ID     Agency     Date          Amount
59     AAA        6/22/05      $50
59     AAA        7/1/05         $0

I have linked two tables, one of which has blank fields and therefore doesn't
return any line item with a blank.  How can I say =or("",>0) in my query
criteria so that no matter what is in it?  OR is there a way to say return
anything that is null or not null in case there may ...

I have a strange problem with this very simple Access 2003 database. Here's
some background: The file was created in Acc2k format (I will need to share
it with people using Off2k) and it has only a few tables and a couple of
forms.

I have several queries that look at a particular table that is imported the
first of every month, the queries then run and will give an inventory of
specific categories in the table. Right now I manually edit all the queries
to reflect my "D/L Date" field to the first of every month ...

I've got a form which has a listbox with 4 columns of information. I need to
base the criteria for a query on the second column of this listbox. I've
used the Builder to get the reference to the listbox, but once I add the
"Column(1)", it suddenly doesn't seem to understand the ...

I have a query done with a column called Bar Service, it's a Yes/No coloumn.  
Not all of our events has Bar Service so sometimes the answer is NO.  I want
to have another column that gives me the total of "Yes" for Bar Service.  
What would my formula be?

I have a database with species records - the species table lists sampleID,
species, abundance, etc., a sample table lists samples, dates, recorders and
other information.  I want to produce a table that will list each sample
along with a combined (comma separated) list of species ...