Recent content by bigzebra

Thanks Kryst51! The criteria I added to the field in the query was: <>'none' . That eliminated nearly all unwanted records. It still printed 2-3 (don't know why) but that was better than the scores it would have printed.

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...

WayneRyan & Banana, Thank you both! both suggestions work! (of course!)

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...

Excellent! So I should add a record ID field to my database? There isn't one there now. There are 152 records in the database. Thanks.

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...