VBA, Wildcard as a parameter

Wildcard as a parameter

Author	Message
David Fric #1 / 3	Wildcard as a parameter When I pass a parameter to a query, it acts as the criteria to select specific records. But how can I make a parameter query return ALL records? I tried using the wildcard ( * ) but this doesn't work. The alternative I am using now is to have two queries: one a parameter query and one a nonparameter query. Is there a better approach? Thanks Dave -------- David R. Frick & Co., CPA http://www.--*.com/
Thu, 04 Jan 2001 03:00:00 GMT

orangene #2 / 3	Wildcard as a parameter try this I go it from the northwing: SELECT Customers., Customers.CustomerID FROM Customers WHERE (((Customers.CustomerID) Like "" & [Me])); Quote: >When I pass a parameter to a query, it acts as the criteria to select >specific records. >But how can I make a parameter query return ALL records? >I tried using the wildcard ( * ) but this doesn't work. The alternative I >am using now is to have two queries: one a parameter query and one a >nonparameter query. >Is there a better approach? >Thanks >Dave >-------- >David R. Frick & Co., CPA >http://www.frick-cpa.com
Thu, 04 Jan 2001 03:00:00 GMT

Karl Irvi #3 / 3	Wildcard as a parameter The following query syntax will select all records when you press enter instead of entering a parameter. Like "" & [Enter mfg] & "" Quote: > When I pass a parameter to a query, it acts as the criteria to select > specific records. > But how can I make a parameter query return ALL records? > I tried using the wildcard ( * ) but this doesn't work. The alternative I > am using now is to have two queries: one a parameter query and one a > nonparameter query. > Is there a better approach? > Thanks > Dave > -------- > David R. Frick & Co., CPA > http://www.frick-cpa.com
Thu, 04 Jan 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]