I'm attempting to set up two combo boxes on a subform (Subform1) that exists
within a larger form (Form1).  The first box (VENDORS) lists "vendors" and
the second box (PRODUCTS) lists "products" for each individual vendor.
I have a table (VendorTable) that contains a list of all ...

I use a crosstab query to look at one week's worth of data each day.  The
column headings created by the crosstab query are dates for example, 4/5/2005
4/6/2005 4/7/2005 etc.  If I use the dates on a form, tomorrow they will be
different since they will all be incremented by one ...

Is there any way to put in a calculated column in a query that will start
at 1 and increment by 1 (as a counter) so that when I use that query in a
subform, I can take that field and use it to number each record on the
subform?

 Can I use an update query to make the value "" ?
UPDATE " & sTable & " SET [" & sField & "] = " & _
           "'" & sValue & "' " & _
           "WHERE [Date]=#" & sDate & "#;"

For months I've been trying to work with Dsum.  But, I'm just not getting it.
Pls help !
I have a query named qryAttend1 with 3 fields: ss, Chg, qDate
The original table containing all the info is called Attendance, but I

I have table called Curr_table
and the fields are  Curr_code , and the items under that (USD /GBP/EUR)
                          Curr_rate ,  and the rates (0.295 /0.595 /0/335)
and another table called Fx_ladder

I have two tables in a data base - New Customer and Old Customer
The key relationship fields in each table is the Customer Number
The New Customer number in the New Customer table is 7 positions alpha/numeric
The Old Customer number in the Old Customer table is 6 positions ...

I have a list box on a form. the reason i have used a list box instead of a
combo box is that id like to be able to do multiple selections from the
control.
Basicly fill in the fields on the form click the run report button and the

 I have a query that pulls a month worth of figures and puts them on a
excel worksheet... I would like to add 2 calculated fields to the end of the
query but not sure how to do this...
Here is the SQL as it stands now...

Here is my problem:
I have a database with orders, order details and tblproduction. What i want
to do is the following:
Get a query to collect information from order details sorted by productID

I have a problem to run a query like this scenario:
i have players in a table who have scored in many matches and i want to take
the 5 latest.
The latest i want to multiply with 1.0 and then after with 0.8, 0.6, 0.4 and

I have a database that has two table (game1) and (game2), both tables have
id, formation, play, attempts, and yards.
I want to create a query that will list all of the records from both of the
tables in the formation field.

The field "AccountNum" is 21 characters long. The department number is
imbedded in the "AccountNum" field beginning in position 8 for 4 characters.
In an Access SQL view I am trying to use the SQL substring function but
Access query does not recognize it.  substr([tablename ...

Hi,
How can I select a union record set from two tables while having different
number of columns?

I am working with a query in which I want to determine the elapsed time
between date values in different records.  The application is a database
containing animal records.  I have a table that contains birth information.  
Each record contains the data regarding a birth event (the ...