hi,
i kind of urgently need help, i doing a database and there is a
problem i encounter.....
i have three field a name, date and currency - when i use group by for

I have a table storing the test dates, student names and the grade of
the students. I am now going to find out those dates with student1 got
A and student2 got B and vice versa (i.e. student1 got B and student2
got A). How can I do that? I think it is quite complicate for me.

I have two update queries in a Microsoft Access database with the same
SQL, but one runs in <0.003 sec and the other runs in >2.000 sec. The
second one is slower because it has a query plan that is not optimal
for the data currently in the database.

I have read many of the threads on this forum re: ranking records but still
fail to have any success.
In my query below I have my data is ranked ny the expression
'Capitalisation' and sorted descending. I simply wan to add a calculateded

I am trying to figure out how I can produce the following:
I need to show accounts that have (0)zero days left before they need to be
paid.
I have created the the following query:

Hi I have a query which selects all the details from a product table, as well
as the account index and date ordered for any order placed for that product
from the purchase order table and finally selects the price paid for that
order from the purchase details table....what I am ...

I am creating a database for a taxi company. The company has pickups
arranged into 3 categories, Current Pickups, Bookings and Contract
Pickups. I have created a separate table for each type of pickup.
I want to search pickups by entering the DRIVER ID, FROM DATE and TO

How to add potential nos to list in table but append to column in another
table?
2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....

Good morning,
I am new to "UNION" and am attempting to combine severa same detail/info
tables into one for reporting purposes.  I have a 2 part question.  
1:  my table detail is being linked via Excel to Access - the Excel field -  

i'm taking access 2 i've saved my work but now i want to use lookup wizard
but my computer won't let me it say i have to cancel my relationship that i
have created i tried deleating the relationship but i still can't use lookup
wizard can someone please help me thanks

I have a database which has a table which is used to summarise future
events. I am trying to write a query which selects job_id from the
table where the value of field called CCT is found in any other record
under a set of fields called RC1 , RC2 , RC3, RC4. I have tried

i have made a crosstab query in which row heading is "date", colum
heading is "aircraft type" and the value to be summed up is "1-10 row
totals". i want to create a simple query which should just give me the
total value of "1-10 row totals" field by defining a certain criteria.

I have two queries which are different due to its complexity, but has the
same number of data fields.  Query 1 has no unique field, query 2 does have
a unique fields.  I like to make it into one query for example:
Query 1 (All fields are now shown for simplicity)

Thanks so much in advance.
I realize you all volunteer your time and it is much appreciated.
I have read Allen Brown's tips, and many other examples i.e North wind DB
etc...

I have the following expression which works nicely to group all of my dates
into their respective weeks of the year, by week dates beginning Mondays:
WeekStart: ([MyDateField]+1)-DatePart("w",[MyDateField],2)
However, since the week beginning 12/26/05 crosses over both '05 and '06 ...