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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,478
Messages
5,770,321
Members
425,612
Latest member
martinijr

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