Export crosstab queries

**sk88** · 02-24-2015, 01:11 PM

Need help

I have a cross tab queries where user can enter date parameter to show the results

Code:

[Enter Start Date "dd-mm-yy"] with data type Date/Time 
[Enter End Date "dd-mm-yy"] with data type Date/Time

with

Code:

Between [Enter Start Date "dd-mm-yy"] And [Enter End Date "dd-mm-yy"]

under criteria under DATE field and the Total is set to WHERE.

When I hit export, it ask me to enter the date parameter twice. Any idea?
Thanks

**June7** · 02-24-2015, 05:40 PM

Don't use input popups. Use a form for input of criteria and the query parameters reference controls on the form.

**sk88** · 02-24-2015, 08:05 PM

Originally Posted by June7

Don't use input popups. Use a form for input of criteria and the query parameters reference controls on the form.

Thanks June7. Would you be able to provide codes for that? I tried the below code and it gave me an error:

Code:

Between [Forms]![FormName]![StartDate] And [Forms]![FormName]![EndDate]

I have a form with fields called StartDate and EndDate
Both fields are unbound fields.

**June7** · 02-24-2015, 10:44 PM

So the form name is Export and that is what you actually used, not FormName?

See if this helps http://allenbrowne.com/ser-67.html#Param

**sk88** · 03-02-2015, 03:53 PM

Originally Posted by June7

So the form name is Export and that is what you actually used, not FormName?

See if this helps http://allenbrowne.com/ser-67.html#Param

Thank you so much! Its working!