How do I set up a crosstab query to act like a parameter query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a cross tab querry to ask for parameter prompts when it is
opened? I am using Access 2002.
 
First, consider abandoning all parameter prompt queries since they have a
very poor user interface and are not very functional. You should use
references to values of controls on forms. For instance:
Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd
If you use this in a crosstab, you must set the query parameter datatypes.
Select Query->Parameters and enter
Forms!frmDates!txtStart Date/time
Forms!frmDates!txtEnd Date/Time

-- Duane Hookom
MS Access MVP
 
Back
Top