I need a query that will get the latest LEVEL for each student. The way I
think we can do it is:
get Level_At_Date
for MAX of Record_ID

I have a table that has a column that identifies supplier.  It resides in a
table that is a parts list.  I'd like to perform a query that would give me a
list of suppliers in the table.  There may be 1000's of parts from the
supplier, but I'd like result to show 1 reference to ...

I have a query, several tables, 1 to many, yada yada.
I have several fields I use criteria in, for date ranges and stuff, and
one field called brand_id, a long integer.  Values for this field range
from 1 to 27 in this field.

I have a field that contains summaries of articles.  I want to search
within the field for the following:
"Red" and "Blue" or "Green" and Blue"
I want my results to return all articles that contain both "red" and

A form displays data from a query. There is a button on the form to
delete the record. The query is based on 2 tables (Appts has appt
info, and other table is person info). The tables are linked by a
field in the query (by SSN), but not in the database's relationship

Could anyone suggest good web resource to learn SQL.
I have a good handle on access as a whole but lack knowledge in SQL.  I can
do basic stuff (select, where, into,...) but would like to learn more about
combining queries (subqueries)...  I often have to create 3 or 4 simple

Hi. This Delete doesn't work, why (I'm getting this error: "Specify Table
containing the Records you want to Delete")?
DELETE Table1.Field1
FROM Table2 LEFT JOIN Table1 ON Table2.Field2 = Table1.Field1

I'm not sure if this is possible or not.  I have imported Duane Hookum's
DH_QBF (which is so fantastic if you're reading this Duane!) and am modifying
the queries to suit the reports that I need to make.  I have a series of
fields that are joined together (see below).  I have ...

I am using the following expression which works perfectly when I use a local
table. When I use the table that is ODBC linked to a SQL table, the
expression brings a null answer set. Between Date() And
DateAdd("d",-6,Date()). One more thing - is there any way to write the

I am running a query with this in the criteria field:
IIf(DateDiff("d","Arrival Date",[Start Date])>[Rates]![FreeDays],[Departure
Date] Or IIf(DateDiff("d","ArrivalDate",[Start
Date])<[Rates]![FreeDays],((Max Charge Days Total-[Rates]![FreeDays]-DateDiff

           I created a query that searches in 3 fields (soon to be more)
for matches.  I wanted to create a report for it so i used the reports wizard
and it looks great BUT, it doesnt work all the time.  Sometimes it works,
other times i click and nothing happens and when i use ...

  What criteria should be placed in the query so that it should look up
values in the field that start from Date1 to Date2. I have this criteria:
"Between [Forms]![Form1]![StartDate] And [Forms]![Form1]![LastDate]" which
only looks for values in between (I know, it only includes ...

I currently have multiple records per client in a table and would like to
reduce it to ONE record per client in the table.  However, I would like to
capture the information from each of the records when reducing to one record.
For example:

I have 2 tables (tServers and tTimezone) with the following structure:
tServers:
servername
city

I have a database and I display some records in a subform according to some
criteria (so far so good) Now I would like to select on the subform a
selection of the records shown (result of the abovementioned query) and then
perform using a commandbutton some actions related to the ...