U
underdog
Guest
Hello, I'm sure this question has been asked and answered many time before, I just need to be pointed in the right direction.
I have one table with 25 fields
I wish to create a form with at least 5 fields where I can enter critera and then use that criteria to search the table. If a field is left blank, I would like that field ignored and then the move to the next field. I tried doing this through a query by using AND/OR but am having no luck. The query displays no records.
I have fileds named:
VendorNumber
VendorName
PONumber
InvoiceNumber
Status
I would like to be able to use one or more of the fields and be able to enter partial criteria. I looked at a database that jfgambit posted and it's exactly what I need but just can't wrap my head around how it works. If someone can shed some light on this, it would be so appreciated.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47551&highlight=attached
Thank you
I have one table with 25 fields
I wish to create a form with at least 5 fields where I can enter critera and then use that criteria to search the table. If a field is left blank, I would like that field ignored and then the move to the next field. I tried doing this through a query by using AND/OR but am having no luck. The query displays no records.
I have fileds named:
VendorNumber
VendorName
PONumber
InvoiceNumber
Status
I would like to be able to use one or more of the fields and be able to enter partial criteria. I looked at a database that jfgambit posted and it's exactly what I need but just can't wrap my head around how it works. If someone can shed some light on this, it would be so appreciated.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47551&highlight=attached
Thank you
