crosstab query

P

Pammy

I have a crosstab query that runs. It is based on employee time,
Employee 1/1/2007 1/2/2007 1/3/2007..........
Doe, John x x x
Doe, John hol exc sk bank
Doe, John wrk.......
Edge, Jim
Edge, Jim
Question is there a way to run the query and let it show Doe, John on the
first row and continue with his infor on each line until it reaches the next
emp and have that persons name one time and so. I would only like to see the
name once until the next name and then all his lines of infor then the
next........
 
K

KARL DEWEY

Open the report that uses this crosstab query in design view, click on the
Employee textbox, right-click and select Properties, set the Hide Duplicates
to Yes.
 
P

Pammy

I do not have a report based on this query because it has parameters. I do
not know how to write code for a crosstab parameter query report. This is
why the query is working, I just wanted to hide the emp name after it
generated until the next name appeared.

Thanks
 
K

KARL DEWEY

I do not have a report based on this query because it has parameters.
What has parameters to do with building a report?
 

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

Similar Threads

Crosstab Query Issue 1
Query design 1
help me 2
crosstab queries 1
update crosstab 0
how do I create supervisor hierarchy with the access table 2
Crosstab query error 1
query to locate which record was not added 2

Top