Is there a way to use a parameter query to print "X" number of copies of a
report.
I have a form with a command button that prints a report based on a query.
If I need 6 copies, I have to print the report 6 times.  I can't hard code

I have a linked table, which has information about caribou movement. 4 of
those columns are important to this question. They are Collar(the collar
number), Date(Date when a position was "Fixed"), Time (Time of day when the
fix occured), and LC(Location Class, indicator of Fix ...

I have two tables; MONTH with fields First_ Date and Last_Date which only
shows one record e.g. 2006-02-01 as First_Date and 2006-02-28 as Last_Date
and the other table is SDETAIL with field Posting_Date
I want to delete all the records in SDETAIL with Posting _Dates between

I have 6 fields in a query. All fields come from one source table. If there
is a change to any of those 6 fields weather it be one filed or all 6 fields.
What type of expression can I put into the criteria to catch the change and
update it to another target table. I just need the ...

I have a database containing customer invoices.  Each record includes the
CustomerID, the InvoiceDate and other fields.
I would like to create a query that returns only the most recent invoice
record for each customer.

I am wanting to create a running count for the number of records in my
query.  I have written a query with a date restrictor which should give me
weekly revenue for the last 12 weeks.  Rather than counting to make sure I
have 12 I would like to create a field in my query that ...

I understand that a strong where clause in an append query can eliminate
duplicate records.  I can't seem to find a clause that will work. I've tried
tblMessage.ID not in tblChart Pull-Request.Message ID.  Below is the current
SQL without my failed clause.

Hi there everyone! Using A02 on XP. Love all the help I get here. Couldn't
learn so much anywhere else!
I have a report query that is pulling a PlanYearEnd Date from my table and I
am calculating the PlanYearBegin Date with this in my query grid field lines:

I built a query that queried 4 fields for "Is Not Null". They were OR'd
so that a hit in any would result in that record being selected. I then
went back and added an interactive date selection capability. My date
selection looks like this:

I have a database that has fields such as: ID, Court Name, Address, City,
State, and Zip.  I need to know if there's at least a court name such and
such appears at least once in the state of NJ.  For example, I want to know
if there's at least 1 Drug Court in NJ.  

Below are two From statements and i don't understand Access's use of
parenthesis. I typically don't even use them when making my statements but
Access requires them and i dont' understand them.  
Thanks!

I need some help!!!!
Maybe I am trying to do multiple gings at one with this procedure. But I'm
sort of lost!!!
I have a list box displaying several items.  The same items are also found in

I want to make a screen with buttons as choices for each type of query that
the user can choose.  I have the queries, forms, reports, and macros all
made.  I just don't know how to display a screen with buttons.  I also want
the buttons to be linked to the queries.  I have tried ...

I have 46 individual tables representing readings for different emission
points.  I also have a master table that I'd like to append to daily.  There
can be up to 9 new readings per table per day.  How can I write a query that
updates the master table from each of the individual ...

I have a query which gives me FileNo, Payment Type, Payment Date (a specific
date), Amount. I would like to do a query which would summarize all payments
made to a FileNo/Payment Type and categorizes them by month all on the same
line. For example: