I have data like following:
Student ID    Grade           CLASSS               Level
   1                 PASS        PIANO                   A
   1                 FAILED      GYM

I have a database of historical recipes with a subdatasheet listing every
ingredient for each recipe title. I want to produce a query that will return
all the recipe titles that require a particular combination of ingredients.
Somehow the way to do this eludes me! I could search ...

I have a database of test scores, where I need to figure out averages.  
However, the test is administered in several ways - computer, paper,
terminals...  I need to figure out how to create a query (one rather than
three separate) that will allow me to figure out the averages ...

Although the article below claims that Access 2000 boasts the REPLACE
function, it isn't recognized when I try to use it in queries (pity this
wasn't made clear either in the article or in Access 2000 help). However, if
I use it in a module, as per the example , it is.

Hello all, i would like to show all records printed between two dates. My
date format is 01/01/07. The table which i am using has this format
My first column has this, Days: DateDiff("y",[Print Date],Now())
I used the following which is not working. Between #01/01/07# And ...

I have a database that contains several fields that are checkboxes (i.e.,
Yes/No data types).  Using Create > Query Design, I know how to easily create
a query which returns all the records where all the fields are checked (by
specifying Criteria =”Yes”) , which is an AND ...

I want to calculate totals for Phases from rows that contain multiple Phases.
Table is similar to this:
Fields:Phase     total_usage
           A             10

I am not a strong access user, but have trying to learn it by writing a
scoring program for a Scout event at the end of May.   I have created a table
for each event (there are 24 events) and have made forms that allow someone
to data enter the data from hard copy scorecard.  So ...

I need to submitt a report weekly the lists my project time for the week.
I have a form in Access 2003 that I use to input all my daily activities
into tables.  I would like to create a crosstab report that lists the project
number and cost code as row headings and the days of the ...

I want to compare todays opening price with yesterdays opening price
for 3 stock exchanges with an open price of >= $5.00.
First pass query I get all the stocks with a open price of greater
than $5.00 for yesterday:

Hello -
I have a form that sets the default value of  field  [BomRev] to the value
on another form as follows:
=[Forms]![Main Form]![f_order].[Form]![BomRevMax]+1

I reached a roadblock on my current database.  I have multiple tables for
data entry for each type of product we run.  For example, product Crag 4/6
has it's own table of data entry and Island 4/6 has it's own. Each product
has it's own lookup table of flavors depending on the ...

table :
Name , Date
how to make a query to group records by name having countofname for last 4
weeks as one group and for last 12 weeks ( without last 4 weeks ) as a second

I would greatly appreciated some help in building a Query that would check a
Training Date Column and return the results in another Column that if the
Training Date is more than one year ago, then it will return a value as DUE
otherwise OK. Please make it simple for a beginner.

I am wanting to do a search that will show me records within a specific  time
frame. I have it set up now to enter a Pay Period Start Date and End date but
I want to be able to get the results without entering so much info. I want to
be able to put in the start date and then have ...