I have tables containing the same fields, with each one holding data based on
a different date (e.g. market value at MMYY).  However, each month some
records (accounts) drop off and some new ones come in.  I would like to
create one "master" table and/or query that tracks ALL ...

Any Idea? I want to create an append  query.......but how can i go about?
I like to transfer data from this horrible table:
tblMSM:
fields:                         ID, | ModelNumber| Spring| Border  | Qfill1

Hi, I'm a new user since last week.
I made a query that calculates wages based on the pay rate and hours that
are entered in the original table.
This calculates the motnhly wages for each employee, but I need a Totals row

With much help from this discussion group, I have a query based on a table
that I will continue to add to.  I need to be able to query by specific
dates.  The dates do not show up anywhere else in the query and I am not sure
how to set up the parameters for the start and end ...

I have an append query that places all the vehcile in our fleet into a
Monthly Mileage database.  Is there any way to have this append query to
automatically run on the 20th of every month without me having to manually
run the query to do this?

I have a temp table which i'm populating with a cursor thus
OPEN c
FETCH NEXT FROM c INTO
@client_uno,

I am going mad trying to extract the data from this query as the date
parameter does not seem to work!
The SQL is as follows:
SELECT [Job Transactions].[JOB REF], [Job Transactions].TRANSDATE,

I'm able to count the number of business days between two dates, but now I
need to calculate two business days out from a date field.  Can you tell me
how to do this?
The count is done in a query using this criteria that I got from another post:

Thank you for using time on my issue.
Year         Round            PlayerID       Total     Points     Par3
Par4     Par5
                (1-6 pr year)

I have a dollar spread of a period of 12 months, but only want to average
the month amounts that have numbers in them.  I.e.  We are in march and have
numbers in the january, february and march fields.  I want these 3 averaged,
excluding April-December since they have null values ...

I have created a select query to start with to calculate the balance on an
invoice. The query uses only one table (OpenAR). I have a calculation which
takes the Inovice amount and subtracts the payment amount and then the
adjustment amount to give me an open balance. The problem ...

i'm almost finished writing a DB for a company and today comes the owner and
tells me that he wants the DB to make a report of everything the users did in
the day!
i don't know if i'm too tired or what but i can't think how to go about doing

I have two tables - 'staff' and 'appraisals'. The 'staff' table holds basic
employee information, the 'appraisal' table holds dates of appraisal meetings
and comments for that appraisal.
I’d like to create a query that shows me all the staff information for all

Hello, you guys have helped me out on other ACCESS issues.  I have a
query that excludes certain criteria using a Between and clause but I
need to exclude more cirteria from that query and I can't seem to get
it right.  This database tracks advertising on buses by side (three).

I have two tables that I am working with. Both of them have order_number so
that could be the relationship. I am trying to get the order_date from one
table to the main table only if maintable's order_number = secondary
order_number. The main table has the column for order_date ...