Search results

Greetings, I would like to skip records from the table and not print them in my report based on a value of a field, for example 'none'. How do I do that and where does the code go? Is it an IIF statement in the Control Source of the Data tab of the field? Can someone please provide a coding...

Good afternoon, Can someone tell me why my SELECT statement is not returning a record? When I hard code the record ID (12) in the SELECT statement, the record is returned. I want to grab any record ID from a form and use that to search the database, so I have a variable in the SELECT...

I have an Access 2003 database that uses last name as primary key. I have a webpage I'm developing that will search the database based on names in a drop down list. There are duplicate last names, eg Smith, Brian and Smith, Jack in the database. Can I imbed an unprintable character in the...