i have this form, that has four possible experiments per record per project
number. Each experiment has a main resin and 3 additives or 4 ingredients,
therefore  possible of 16 ingredients. conversely, each ingredient is
associated with a entered supplier, therefore 16 suppliers,

I have follwing data to create crosstab query and column heading is
Grade.
Student ID GRADE
 1                A

I have two tables, one with projects, one with construction agreements. I
need to delete 3 records in each but when I try it says they can't be deleted
because there are related records in the other table. I am a little bit
afraid to write a delete query myself. Help!! Thanks so ...

I am requiring the user to enter three parameters for a query and I'd like to
control the order in which they are prompted for.  Two of the parameters are
called for using square brackets (with prompt text enclosed) on the Criteria:
line, and the third is called for similarly but ...

The criteria that I am trying to determine is to have a user input a number
and then the query show all the records that have a value of greater than the
number inputted by the user.
This is the criteria I was trying to get to work:

running access 2000; I have a contacts table with name address phone
etc...
I'm trying to make a "find duplicates" query work, and am failing.
When I try to execute, i get an error message similiar to: "tried to

I'd like to have a recursive query that refers to itself, but I have
run into the 'circular reference' error.  Is there a workaround
that'll let me do something similar?
As a test for a larger version, I have a table [TestRecurse] which

I am using access 2007 and have a huge database will lots of queries.
I tried to use the new feature in 2007 that allows you to group
database objects in categories.  After doing this when i try to open
the queries in design view to make changes, I get this error: " is not

Good day,
I am not sure how to do this but here is what I would like to do based on a
query.
I have a table with the following information and field names

I deleted a couple rows when compiling my database.  Now it goes from ID
number 1 to 6.  How can I fix it and make it number 2 and go from there?

How do i create a query that grabs only records where the Offering_ID field
ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts
users to enter this info.  The records in the 'Offering_ID' Field are not all
the same length though.  

I am creating a database to retrieve performance information at different
levels.  The lowest level is an individual area, then going to a group area,
then to a building level.  I am trying to limit the number of queries by
pulling it all off with conditional criteria.  The query ...

Afternoon all,
Is there a function in Access that does the equivalent of an indirect
function in Excel?
I have created a query and want one of the fields [AB] to be populated with

Sorry...this is a cross-post (is also in "General questions", but NO replies
yet...if this is doable).
I'm uUsing automation to Excel.
Can I get the Column Headings..IE - Apr - May - Jun - Jul...

I never would have made it as far as I have without answers that I've found
in this discussion group, so I will thank you in advance for helping me with
my sticking point.
I have a query that I am using to generate a random selection of customer