Hello -
I have to map the fields from a bunch of old tables to several new tables.
I would like to output the Append Query designs to an Excel or Word file so
I can document the mapping for my client.

I have two tables (bds and ta) where each table includes a zip code that can
range from a minium of 5 digits to a maximum of 11 digits. I am trying to see
if it is possible to write a query to match on the zip code field for each
table. I am running into a problem when the bds ...

Just a quick question, in the query design window, how can I update a list
of number to +1 from the final number in the list
TIA
Lez

I have a dataset that looks like this:
CREATE TABLE Scores ([ID] IDENTITY(1,1), StudentID INT, SubjectID INT, Score
FLOAT)
I want to get the lowest score and the subject for each student.  So the

I've read some of the previous threads regarding this and for some reason I
can't get the suggestions to work. I'd appreciate some help with this. I have
a table with a field that has 10 digits (numbers only) with leading zeros
where necessary to fill out to 10 digits. I need to ...

I use to be able to use the Left() function in access queries basically to
filter out all records that started with the same left text (say
"Sub-Assembly" - 12 charactors). Left function is not supported in Access
ADO, and it is telling me to use a Convert function.

Under Word/Access 2000 i used a query to input Access data into into a
Word document (joining).
In the Access query i had a criteria for wich a message box opened so
i could input the selection criteria. So when i opened the Word

I posted before on this, but I didn't get any solution.
I base a crosstab query on a query which includes 2 subqueries.  The
query runs fine, but the crosstab query fails with "The Microsoft jet
database engine does not recognize 'table1.table1ID' as a valid field

I want to thank both John Vinson and John Spencer for help on my
previous "Max Date" problem. The final solution was to use the
following SQL:
qryInspectionLatest

I am currently trying to run a query that will give me a report coming from a
table with these fields: City, Trailer #.  I need the query to list the
trailer #'s for each city within a certain date range.  However, I only need
it to show the total amount of trailers for each city ...

How to get Access (2003) to return every different entry in a field and how
often it occurs?  i.e.  The field "Qualifier" contains probably 5-10
different qualifiers (<T, =<W, null, etc.) in a million-record database.  I
don't know in advance what all the different qualifiers are ...

I have a query that I run from a Command Button on my Switchboard that I
ultimately need to export to Excel.  When I click on the Command Button
(using 'DoCmd.OpenQuery'), the prompt appears, and after it is answered by
the user, the query runs fine.  But when I go to File... ...

I have a query that is pulling from a table the previous days data using
date()-1.
I have addressed the problem if I'm running this query on a Monday then the
table's last days data would be Friday (the last buisness day) so date()-1

I downloaded the contract management database for Access2003. I have
two questions
1. The contact management has a field titled "Subject" I have changed
it from" Text" to "Memo" Data Type. I created a query to search for

Is there a way to capture the username in a query / form?  Any edits to a
record will show the last user who altered the record.
Thanks!