I was trying to find the number of items sold by a specific product ID number
in queries, but i can't figure out how to do it. does anyone have any advice
on how i could achieve a task like this?

I have two fields: StartDate and EndDate.
Ex: StartDate   EndDate
    01/15/07     05/12/07
    02/16/07     08/10/08

I would like to create a query that totals two fields based on date.
Add and show the total hours worked and total pay for each month.
The date field is a long date/time field
the total hours is a text field

I have a table:
consists "ID" , "Product name" and "Result".
IF the colum "Product_name" contains word "vita" or "Acid", the next column
should show "YES" else "it should be "NO"

Hi, All:
I have a form, it contains a combo box it displays three columns, a
Table/query was used as a row source, it has two text boxes  contain
coulmn(1) and column(2) values of combo box, separately.

my problem is that..
i have a database with one table including 3 check boxes.
what i want is when the three check boxes are filled to automatically send
an email in a pre-defined adrress.

Hello and thanks in advance for your time.  
I'm putting together a database of the City and Zip Codes some of our
shippers ship to, but I've run into a bit of a situation.  Some of the zip
codes I've received from them(around 4500 entries) are in a range format (ex.

The following SQL script works fine:
SELECT [Works_number] & [BT_SCP] & [Test_code_2] AS PSCP, Count([PSCP]) AS
Expr1
FROM Main

I have a date field called "enddate" and a field called "active".
I want to make it so if the enddate is before today to put "no" in the
active field, and if greater than today to put "yes" in the active field. I
have done it in a query many times before and know it was something ...

I am importing a file into Access that contains one or more sentences.  I am
trying to figure out a way to drop everything but the first sentence.  The
problem is that the sentences are of differing lengths.  Basically, I think I
want to drop everything past the first period that ...

No data appearing with the following:
Linking to tables with a left join. Data appearing from first table but no
matching from second. HELP!
SELECT [IRB Separations (April 1, 2006 to March 31, 2007)].EMPLID, [IRB

I have two fields: StartDate and EndDate. I would like my qry to pull out
all students who are at my class  between StarDate and EndDate that I supply
as parameter.
Ex:

I have a query that produces results of the total number of errors each
employee has made in 5 categories for each month.  I need a rolling 3 month
total for each employee for each category in a crosstab query
i.e.

I'm trying to generate some random numbers in a query in order to allow a
random sort of the query using a calculated field called Random: Rnd().
Problem is, the exact same random number is generated for every record in
the query thus negating any ability to create a random sort.

my data looks like the following
111    0    01/01/2007
111    0    02/01/2007
222    0    04/01/2007