I´ve neary managed to join 3 queries in a Union query, but one problems
remains.
The amount of columns is different between the 3 tables, and I would
therefore like to add empty columns to 2 of the queries.

I have a clientTable (clientID[key]) linked in a 1:many relationship with an
eventTable (eventID[key], clientID, eventType, eventDate, eventDescription).
I would like a query to provide only the most recent eventDate and
description for each eventType grouped by client (clientID) ...

Hello all...
I have an access table with around 2000 records. But few records are
duplicated. e.g. Say Record for student John is repeated twice in the table.
I want to delete duplicate records for which "Student" and "Class" fields are

I have a table recording monthly reading. How do I get the reading for last
month?
Any reply is highly appreciated.

I am using Office 2003 on Excel XP.
I need to append all records from T1 INTO T2, if [T2].[Period] = 2 and the
account number appears in T1 but NOT in T2. Would the following SQL do the
trick?

If I have a column containing one or more first names eg Bill Andrew Mike and
I want to extract the first name in the column (eg Bill) I can use SQL code -
Left([names]),Instr(1,[Names]," ")-1) however if the row only contains one
name the query returns an error for that row. Do ...

I want to create a summary of events based on two date criteria.  I want a
total of how many times the date is not empty for each field value.  If I
create a query with the two fields and use count, I get the same number
value for both.  It is to track how many lots in a ...

I have a query that Ken Snell helped me with.  It detects missing dates in
my employee timesheet db.  My query has a field of [D] form tbl "Q", a field
of [FirstDay] where a date was entered indicating the employees first day of
work for the season, and [LastDay] for the date the ...

I have a query that gets a value from a table.  How do I pass that value to a
variable?

In a query I am importing data from another program and appending it into a
table, The data being imported has phone number fields in the format
(123)456-1234
I need to remove the brackets and the dash from the data so the phone number

I have a database with 2 tables (one with names of 3 people and one with the
things that they will do every hour). Now i want to make a query with these
2 tables and i want to get this result:
Name              14                    15                    16

I have SQL lookup that does not do exactly what I want.  I am new to
Access and SQL so I am doing some practice databases.  I have a table
with 3 fields:
Table - Counties:

I have 2 tables, Countries and States.
Countries is setup like this:
2DigCode    = Primary Key
3DigCode

I am trying to get either the counts of or sum of data from a table
with gift amounts to display within certain ranges (e.g., $1-$99,
$100-$199, etc.) . The query is as follows:
TRANSFORM Sum(tblGifts.GiftAmt) AS [The Value]

The following is an extract from the WHERE element of a SQL expression
behind a select query which, in this instance, returns a record whenever the
Genre field contains the word "blues".
WHERE (((Products.Genre) Like "*blues*"))