[AccessD] Crosstab Querry with parameter on Form (A97)

Steve Grant steve.grant at stgsolutions.com
Mon Mar 10 08:48:00 CST 2003


Hi Gustav, 

Tried it and it did not work either.


Steve

-----Message d'origine-----
De : accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]De la part de Gustav Brock
Envoye : Monday, March 10, 2003 09:08
A : Mike and Doris Manning
Objet : Re: [AccessD] Crosstab Querry with parameter on Form (A97)


Hi Mike

Try specifying the two parameters

  [forms].[frm_Param].[txt_StartInvoiceDate]
  [forms].[frm_Param].[txt_StartInvoiceDate]

as date/time.

/gustav

> I have a query that uses a form to get it's parameters.
> This is what's in the criteria section of the query.
> Between [forms].[frm_Param]![txt_StartInvoiceDate] And
> [forms]![frm_Param].[txt_EndInvoiceDate]

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list