Report based on a parameter/crosstab query

A

AH

Hello everyone,

I am sure my question is simple and I refuse to believe
that Microsoft overlooked this simple problem.

These are the steps I have taken to create the Query:
1. Created a table with 4 fields:

name date time direction
-------------------------
user1 1/1/03 8:00 In
user1 1/1/03 17:00 Out
user2 1/1/03 8:05 In
user2 1/1/03 17:15 Out

2. I created a crosstab query:
a. Row Headings are: name & date
b. Column Heading: direction
c. It then asks me, What number do you want calculated
for each column and row intersection? time is the only
one left and under function, I choose "first".

Everything seems to be ok so far with the query listing
the following:

name date TotalOftime In Out
-----------------------------
user1 1/1/03 17:00 8:00 17:00
user2 1/1/03 17:15 8:05 17:15

Now comes the part that might be the trouble part. If I
create a report at this time, everything goes ok, but I
would like to have my report prompt me for "name" of the
user. So, In the Query I do the following:

i. I add [User Name:] in the Criteria under field: "name".
ii. I also add [User Name:] in the parameters under the
Query menu or else I get errors.

3. I then try to create the report, but I get no fields
listing when I try to use that query with the Report
Wizard!!!

This is driving me crazy (Have you ever seen Daffy Duck
go crazy?!)

Please help. Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top