Access SQL Wildcard in WHERE statement. - TechRepublic
Question
March 5, 2008 at 04:09 PM
mandw

Access SQL Wildcard in WHERE statement.

by mandw . Updated 18 years, 4 months ago

I have an Access SQL statement (Using Access 2000)that contains the line:

WHERE ((([tblResupplyOrder Numbers].[Our Order Number])=[Forms]![frmEditOrder]![Combo51])

This query is used to populate a report, but being conditional it only works when I drive it from form [frmEditOrder].

I want to wildcard [frmEditOrder] so that any form with a Combo51 can drive the query and the report.

Otherwise I have to replicate the query and report with a new form name for each one.

Thanks in advance for any help.

This discussion is locked

All Comments