B butter30 Registered User. Local time Today, 23:31 Joined Jan 24, 2010 Messages 12 Feb 28, 2010 #1 hey does anyone know to create a parameter query for a field format of yes/no i tried [enter yes/no] then typed yes it doesnt work say expression is incorrect or too complex HELP please thank you
hey does anyone know to create a parameter query for a field format of yes/no i tried [enter yes/no] then typed yes it doesnt work say expression is incorrect or too complex HELP please thank you
G Galaxiom Super Moderator Staff member Local time Tomorrow, 10:31 Joined Jan 20, 2009 Messages 12,832 Feb 28, 2010 #2 The forward slash might be causing trouble. If removing that doesn't fix it then post the complete sql of the query.
The forward slash might be causing trouble. If removing that doesn't fix it then post the complete sql of the query.
M Mr. B "Doctor Access" Local time Today, 17:31 Joined May 20, 2009 Messages 1,932 Feb 28, 2010 #3 Have you tried: [Enter "Yes" or "No"]