I have a table that contains students and their grades for 4 quarters.  There
is one record for each student for each class they attend.  If a student
attends 8 classes there are 8 records in the table each containing their
grades for the 4 quarters.  I want to create an honor roll ...

I have a MS Access query on which the monthly report based. Every time it
takes about 5 minutes. But today it took about 40 minutes to run. The Access
is linked to tables on MS SQL server. What might be the problem?

Hello....I need to create a rolling sum for a certain field.  This is the
table and my output fied should be equal to rolling sum.  I would need to
start a new rolling sum for each region.  Is there a way to accomplish that
in one query?

I have a query with a number of resulting records. I need to check if PARTYID
in any of those records equals PARTYID in my subform.
I was going to put code in the AfterUpdate property of PARTYID on the
subform to check the list of records returned by the query. I know I can

I was told that it is easier to do a calculation in a query but I can't get
it to work.
I want to add up a bunch of values in filds to give me the total.
This is what I have entered right now but it does not give me a total it

I would like to set multiple criteria for an SQL WHERE statement. I tried the
following code:
PARAMETERS [MCC] Text ( 255 );
SELECT [MCC / Buses].[MCC Name] AS [MCC  NUMBER], [MCC Buckets].[Equipment

I have a date field, I want to lookback 15 days from today for all
PO's, in the criteria what would I put in there? I know theres a
dateadd is there a datesubstract or something along the lines of that?
It will always be 15 days. Thanks

Hello.  I am trying to combine a Select and Update Query.  Essentially what I
am trying to do is Select Records by a Yes flag, have a statement added to a
subform to say leaflet sent together with the date, the yes flag will then be
updated to No.  I have forgotten most of what I ...

I hope some one can help.
I need to take a specific character(code) from a memo field and place it into
another field. The placement in the memo field is random but the code is
always surrounded by "".

In Access 2000 I have 3 tables:  Profile, Privilege, and
Profile_Privilege_Reference.  I created a query below that lists the
privileges for each profile by department.  Department is stored in the
Privilege and Profile tables.  

I have a table containing inventory. I have created a form that will act as a
"report generator." Users will select values in unbound combo and text boxes
for criteria. Once the criteria is selected a button will launch a
query/report based on the values.

Hello Access Nation, I have two tables that I want to join and get distinct
client records. The tables are for meals at a hunger center. One table
contains breakfast info and another contains lunch info. I've looked at all
the threads but I'm missing something. Any and all help ...

I have a query listing the transit time between two given origin points (zip
codes) and multiple destinations.  I am trying to limit the results to the
one combination that list the smallest transit time -
Min(GND_TRANSIT.[SERVICE DAYS]) AS [Min DAYS]- and if the two origins have ...

Query B gets its results from Query A and populates a form. This works fine.
Now I need to alter the WHERE clause in Query A, but when I do it results in
an error that doesn't make any sense to me.
First, the queries:

I have a data 2.3 in a single data type field.
I get the return 2.3 using select query, but it returns 2.29999995231628
when I use union query even I use round(myfield,2)
I am not sure why the union query return the value.