crosstab queries

P

Pammy

I have a query "Emp" running from a large emp database based on date criteria
- a parameter pops up to input the beg date and the end date. Then I created
a crosstab query based on the "Emp" query, that will group by emp team and
then emp name within the team. Across the headings are the dates from the
parmeters. The row info is correct. The crossquery runs correct. Question,
I need to create a report, from the crosstab query so supervisors can run the
report. I want them to run the report based on the beg date and end date.
When I create the report from the report wizard based on the crosstab query
I get the month name of Jan 1, Jan 2, Jan 3.......as column headings. Is
there a way to run the crosstab query that will ask for the beg date and the
end date? So when I input 2/1/2007 - 2/15/2007, the report will show: Feb.
1, Feb 2, Feb 3..........
 
S

S.Clark

I wouldn't try to display the Jan 1, Feb 1, Mar 1, but instead just the 1.
This would be just the days showing. Above the days, just display the month
name only one time.

Use VBA to discern the month, and hide unneeded day controls (like in Feb
with 29, 30, and 31)
 

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