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
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