I have a Customers table that includes "companyname" and various other details.
I have an Inquiries table and a form based upon it.
On that form I have a combo that looks up the company names and pulls them
through correctly, no problem.

I have created a form to supply parameters to a query, on it I have a
combo box cboCollectionType which lists all the collection types
(Special, Green, Cans & Glass) and also txtStartDate and txtEndDate.
This is great when the the user wants a report based on a specific

I am trying to write a query to produce a report. Of the many fields in my
table "tblIssues", the ones I am trying to summarize are:
Restaurant [Text]
Category [Text]

Where do I begin?
When a user selects a Plan ID (as a parameter) I need the below results to
show.
Example:

How do I count the total number of occurences of a record across many tables?
I need to report on the number of products using a certain part number. This
would be easy if I knew how to use Access, VBA and SQL. I have not even
figured out how to get the query wizard to work on ...

I kind of got stuck with this one.
I'm trying to use a Delete query to delete some records from Table A.
Let's say Table A has three fields: A1, A2 and A3
Then there's another table, Table B, with two fields: B1 and B2

I have a query based on a arrivaldate field and I wish to create a query to
find the number of days to current date.
By this what I did in a query is "dayscovered: =now()-[arrivaldate]
I did got the answer correct except too many decimals which is not a

I have a table with Engineer1 and Engineer2, these are pointing to a
tblEngineer. Having already created a query using a combo, to see which
engineer have attended which "site".
My issue is that when i run the query it only looks at engineer1, how would

how do i get my date field on a form to record only dates and avoid adding
the hours minutes and seconds. Any help will be appreciated. Thaks

I have 10-15 update queries that need to be ran each day.  Is there a way to
create one query to run all of the update queries together?  Any info is
appreciated.
Thanks,

Hopefully this will be an easy one for someone..........
I have a stored parameter query (named exec SPQ_TS_Ins) that I want to
execute from elsewhere (Excel).  The SQL is:
INSERT INTO BbookedHrs ( YrWeekNo, JobNo, TaskNo, Mmonday, Ttuesday,

Hello.  I am trying to use a form's radio button frame as criteria for my
query.  When I run the query I am getting zero records.  I've have hard coded
the criteria with "<>0" and ">0" and all works well which leads me to believe
that the problem is in the SQL.  Also, the form is ...

I am struggling with the development of a formula that calculates the no of
days between two dates that are both selected as a result of IIF statements.  
The formula I have written is:
=(IIf([End Date] Is Null Or [End Date]>=[Period End Date],[Period End

It seems that I cannot do everything right in the specification for a cross
tab query, where I have a schedule for customers and personell as well as
time of the day. I have come so far, that it can be presented alright, but
then the booking table must have the names of the ...

Hi
I run W2K and Access 2K
This is my 1st database. I have created a database that has the following
fields: