How could i have access count the total number of records in a specific query?

A little unusual but I need to build a query using a dynamic table name. I
can do this in VBA code by building a query string and then calling RunSql
command e.g. :-
Dim tblName as string

I want to copy several fields of records form one table to another. However,
each table has an autogenerated field that is the primary key in each. I
would like to use another field that's common to both tables as the primary
key for this record transfer. I've tried an append ...

I am struggling with the following:
I have made a table where a define Case / Description Case / SQL-code
The sql-code is the correct code (with [table]!... etc.) which need to be
checked if a record belongs to case 1 , case 2 , etc.

Access 2003.
First:
I like to create an all in one query that:
- create a new record in a table

I have a Customer table with the normal name, address and other
related information.
I want to allocate a staff member to the customer. I have set a LookUp
setting for STAFF Field as a field to select from table STAFF Details.

I am trying to use a text box formatted as a number as a criteria in a query.
If the box is mt I 3want to select all the records, and if it is not mt I
want to use a <= criteria on the number.
I have got a statement that will work except for the 2nd part of the criteria.

Dear Access Community
I'm a novice regarding Access and have an apperently simple problem.
I want to query the average of a numeric field, without using the "Totals"
approach.

Hello there well I have a question about on how to use the combo box I
already made a combo box in a form to link to a table, now this is a example:
Combobox have this listing from the table
1.Credit

I have to create a separate database for an outsource company where the
records are sent to the 'home' database daily. I need to know if it's
possible to update the outsource table from the home table once processing
has been done. Is it possible to have and update query match ...

I use 6 variations of the following SQL to select values from 6 different
columns of a reference table.
SELECT nz([Forms]![Tabulate]![Score ID]) AS [Score ID], [Penalty
Names].[Penalty ID], [Penalty Names].[fldA] AS [Sort Key]

I have a single address field as follows :-
Mrs Williams, Shruberys, Newtown, St Berriew, Welshpool, Powys, United
Kingdom
Mr Jones, 71 Penny Lane Way, Leeds

Here's my code:
SELECT TblDL.SecNm, TblDL.CUS, TblXZ.SED, TblDL.Ex, TblDL.Pay, TblDL.Grate,
TblXZ.CUS, TblXZ.Ex, TblXZ.Pay, TblXZ.Grate, TblDL.Ctry, TblDL.Stat
FROM TblDL INNER JOIN TblXZ ON TblDL.CUS = TblXZ.CUS

I have a crosstab query that I've created for a Rolling 12 month report. It
works great but now I need to add another value to the query. I know that you
can only have 1 value field, 1 column field and multiple row fields. My
current value field is ShipQty. I need another value ...

I have a cross tab query which breaks out the data using the dates as column
headers across the row. If there is no data for a date, the date is not
listed. How can I get ALL dates, regardless of data, to print and, if there
is no data, to list 0 as the field value?