Update Dates on Report from users entry

ZZSteele

New Member
Joined
Jun 14, 2004
Messages
14
I have a report that was built off a Crosstab query. Everything works great, but the dates are static. The crosstab query pulls the information based on a date range a user enters.

So, when I built the report the dates ranged from 3/04 - 10/04. If a user wants to pull information from any other time, the report will not allow it. I tried to put an unbound text box in the area instead of the dates and build it to a query with the dates, but the field was not recognized.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,437
Hi

If I am reading your question correctly, this can be done but it takes a bit of set-up. What you are seeking are fixed headings on your crosstab report but the values of the headings change depending on the users selection. It looks like this question relates to your previous post on the underlying query.

I answered a similar question in this post but be aware there was a bit of toing and froing to get that one working.

HTH, Andrew. :)
 

daknight

New Member
Joined
Jan 5, 2005
Messages
34
Hope I understand your question correctly; you are trying to get the date parameters entered by the user to show up on your report?
Try this: text box on page header:
="Between " & [Type beginning date] & " and " & [Type ending date]
Darla
 

Forum statistics

Threads
1,148,272
Messages
5,745,790
Members
423,973
Latest member
man_this_is_hard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top