2 tables: a) main table with task information
b) second table with details per task (many rows referring to same task)
How and which query to run when activated by button on a form.
Purpose: to produce a Word doc with taskdescription (from table1) and

I have a large spreadsheet (1200 rows and 25 columns wide) with all the
games my football team have played, arranged  like
Game,Season,Date,Opponents,Competition,Division,Type,Result,Score(us),Score(them)
Venue,Notes,Manager,Goals 1,Goals 2,Goals 3,Goals 4,Goals 5,Goals 6,Goals

I am trying to create a simple database help me make a model railroad freight
car roster that is representative of an actual real railroad.
One table, "Kits", is a list of available model freight car kits.  Another
table, "Prototype", is a list of the freight cars the real ...

I am trying to set up a query which will result in my input of a 3 letter
month and the result will give me all tranactions for that month.  Any help
on this would be appreciated.

This my data:
Number, Type, Amount
1513, XX, 15
1513, YY, 10

When I run the following update query I get:  'Operation must use an
updatable query. (Error 3073)':
UPDATE DISTINCTROW tblProducerAssignments LEFT JOIN qryVolumeSummary ON
tblProducerAssignments.LenderID = qryVolumeSummary.LenderID SET

The following query returns unique combinations and record count of the
[Reporting Unit] and [Group] columns in table [Location] having more than one
[Group] column value.
This works fine, but after saving it and re-opening in SQL view I see that

I have two tables
Table One has two fields, room number and item code
Table Two has two fields, room number and item code
I what to find all record in table One that mach the record in table Two

How do i create a timeline?

I have a query which I want to change its source once in a while according
to some parameters (the changes I want to make are very thorough, so adding a
criteria won't help). Essentialy, I want to create a dummy query, which will
be used for different purposes, and its SQL will ...

I have a form containing a subform bound to a query. I would like to
have command buttons on the form to that would result in the query
result being reordered. For example, the query defaults to show the
data in date order, but I would like to click a button on the form to

I was instructed to import 2 text files into 2 Access files - no problem.
Then compare records between them. Non dups records in second file need to be
appended to the first file. Duplicates are defined as the 5 leftmost chr of
[PostalCode] concatenated to 5 leftmost chr of ...

Combobox on a form is the record source for the criteria in an update Query
which holds the "Between xxx And xxx" values I wish to apply.
The rows are literally "Between" "And" in text format held in a table, for
eg: table rows 1 to 5 look like this:

There is a field in my table that contains dates.
I would like to use the Advanced Filter feature to see only those records
with a date in a given month.  
So far I have been unsuccessful in figuring out the syntax for the criteria.

I have a xls spread sheet of email addresses that I imported into a table
I'll call 'tblOutSideEmail'.  The primary field is employee number.  I would
like to update the changes in this table (email field) to my orginal table
called 'tblLoginRequired'.  I have tried using an ...