Hi,
I have the following scenario for which I cannot get the count to work
right.  I know just enough Access to be dangerous, and have inherited this
design which I need to get performance metrics out of.  

I have a database that tracks insurance information for our various vendors.  
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no).  I have
created a query that will return only the records for ...

Hi,  I'm working on a payroll program for a doctor.  My payroll program works
great with my time ticket program.  Now, they have a small timecard program
that is a little bit confusing.  Their database is in Access and I can access
the data but when I look into the tables the ...

I want to be able to sum by daily amounts and then sum them up so i get a
total for the month gone.  So yesterdays figures will be added to the day
before etc and summed up.  
Amount          Date                   Team

I have the data base as below :
123 BOT      3
123             5
123 Top      2

Access 2000, Win XP SP2
Hi all,
I'm looking for a cleaner way to determine whether or not an entry in one
table has a specific field checked yes or no in another table.

Dear Friends,
I am having a problem showing the MTD figure on every line item for products.
My table is as below tblTestcount
CodeNo (text), Manager(text), SalesRep(text), SrvDate (date), Customer (text),

I have created a database that pulls a text file into a table, cleans it out,
and then displays in a report with appended comments that my users can alter.
Now I have a user request for the option of selecting how many days out worth
of data they want the report to display.  I have ...

I have created a database that pulls a text file into a table, cleans it out,
and then displays in a report with appended comments that my users can alter.
Now I have a user request for the option of selecting how many days out worth
of data they want the report to display.  I have ...

I have a table with a list of people.  Each person have its own Unique ID
and is the primary key - no duplicate records should be created.
The table is imported from a csv file coming in from a client.  The csv file
has the updates on them ranging from new address, telephone, ...

I'm using the following expressions to calculate the number of hours between
[ZeroHour] and [ActualEndDate] subtracting the Saturday and Sunday Hours. I
also have a table [tblHolidays] with a [HolidayDate] field. Is it possible to
create an expression that would allow me to ...

I have been trying with no luck to pull a query of individuals with a birth
date after 8/1/2003 and before 7/31/2004. i am unable to get any information.
when i do get information it is only for dates in july but with all the
years.

 I run 2 make table queries and want them to have a relationship afterwards.
it doesn't have to enforce referntial integrity as i only need to view the
fields of the other table.  
Also i run these queries everyday so new tables are produced everyday and the

Here's my query:
CONum      PONum         POTotal            COTotal         RevTotal
 1                18                 $855
$12,500         -$11,645

How can I get a form, based on a table, to show only certain records (for
example, only paid customers)?
I tried basing the form on a query but it didn't work.
Thanks,