I have a data entry form that lets me add records to a table (and the
related query).   I have a Cmd Button on the form that allows me to Preview
a Report showing the data entered.  Sometimes, the data I have just entered
is not on the report.

Is it possible to have multiple fields with criteria at the same time
so that wehen you run the querey a window with all of the options
appears? I have a situation where the users need to be able to query
the database by a transaction number OR a name. Thanks for your help

I have some dated date as below:
1/1/2005        125487        ...
2/1/2005        125487        ...
3/1/2005        12846F        ...

Need some help with a date function -
How would I strucute a query to have a date criteria that returned the last
15 business days (weekdays, excluding weekends) from today?

I'm trying to figure out how to make the "data" fields in an Access
pivot table stack top-to-bottom within each column category, instead of
side-by-side.
You can do that in Excel (in fact it's the default) by dragging the gray

Hi!  Is there any way to automate the running of Mail Merge?  Automating the
running of the underlying query is no biggie.  But Mail Merging has so many
steps for the user, I'm just curious if automation can be done.
Thanks for your help.  Appreciate detials if possible.  Cheers!

Apologies in advance for the long-windedness of this post, I don't know how
else to phrase it.
I am currently calculating this algorithm in Excel but am having to do it
item by item and figured I might be able to do all items at once in Access.

hello, ive got a query thats supposed to total up the amount of rent that
someone owes for a student tenancy database and use this result as the
control source for a data entry form, its to help inform the user of how much
the student owes.

I have a table with a date/time format field. The dates range from years 1975
- 2005. I want to run a query that will select records with a date range for
just the first six months of each year. Is there a way to write a query for
this? for example:

I am having trouble with my query.  I know how to request one piece o
info from the user
[Enter Acct Number
But...How would I go about asking for multiple Acct Numbers and the

Is there anyone who know how can I set my total in the bottom of a query.
This is how I set up codes:
SELECT STU_METHODS.FIELD1 AS NAME, Count(*) AS [COUNT],
CCur(Sum(STUPAYMENTS.AMOUNT)) AS RECEVIED

I am trying to create a query to calculate distance using latitude and
longitude.  I can't find the arccosine or Pi expressions in Access.  Pi is no
big deal, but I really need arccosine.  I want to just use a simple query to
calculate it.  Any help would be greatly appreciated.

i have linked a worksheet from an excel worksheet to the access database.  I
now have created a query with this linked worksheet to a table that i have
created in access.  I am now going to use this table that I have made in the
query in a report, however, in the report I need to ...

I have three fields in a query PROGRAMTITLE, STARTDATE, ENDDATE.  al
of them from one table.
Sometimes there might be no enddates for events which means the
continue for an unspecified period or continuing everyday.

I have a Training database with 2 queries:
qryA contains fields 'Projs', 'Roles', and 'Skills';
qryB contains fields 'Projs', 'Roles', 'Skills', and 'people'.
QryA is setup to contain all the skills required for each Role for each