I have a query with a parameter from a form that runs just fine, but if I try
to base a cross-tab query it, I get an error that the Jet engine doesn't
recognize the parameter in the first query as being a valid field name or
exression.  I can do a basic select query based on it ...

Until recently I was able to create pivot table queries, now for some reason
I am unable to.
I create my query as per normal, then change the view to Pivot table view
and access crashes, stops responding, and restarts.  I think this is as a

I have five Access files.
Let's say query1, query2, , query5 from those five Access databases.
I want to export results of quey1,..query5 to one Excel file named "Daily
Report"

Can anyone help me with this expression?
I have a report linked to a query with the following fields bieng pulled
from various tables:
[NRP]        Currency: Non Recurring Price

I don't know if there is even such a thing, but I am looking for good
source's for Access templates.
Thanks in advance
D

I have created various forms and tables successfully but suddenly I have one
form which is not behaving as i would expect. When I enter data into this
form, it appears to have been saved in the table, however, when I exit the
form and then go back in to check the data, it is no ...

I have a small application in Access 2000 that generally hides Access from
the user.  They can import data and print it in the required format.  I've
just added the ability for the user to see the report before it's printed
simply by adding a button that opens the report in print ...

I have  textboxes on a report that are filled using a query (Access
2000).  The report has many records, and the records on the report are
sorted by a textbox, txtTestNo.  The user sorts through the records
using the navigation buttons at the bottom of the report.  When the

For some reason, my Access database database does not prompt me any messages
when I run my Append or Update query.
Has anyone had this kind of experience?  How can I make it to prompt me again?
Thanks.

to send e-mail in the format of a table. With tabulations
Inside of the body of the e-mail
How do I do?

I have a Union Query combining the results of 5 Select Querys.  It works
great accept for the Item Field (found in each Select Query), which is
returning it's numeric primary key, instead of the realated text Item Name.  
The Select Querys return the text value.  Any ideas?

Hi, I need to join two fields in the same table into a third field in the
same table.
field 1= group_id (can be 1 or 2)
field 2 = person_id (starting at 001 and continuining)

I'm struggling with something that was pretty easy with WinParadox.  Suppose
I have three tables; People, Phone, and PhoneType.  On my People form, I
want a subform in which the user is able to add more phone numbers to the
Phone table.  I want the user to see two fields; the ...

I agree that this message in a litlle strange, but I have already
tried everything to construct a expenses forecast in access.
My main difficulty is about the construction of the form to actualize,
to include and to excelude values in my table.

I have a form where I add an event and contact to a table with combo boxes
that load the new event from a client table. If there is no contact
available, I have a button that launches a form to add the contact. When I
exit the add contact form I like the field in the add new ...