m3g4tr0n
Last Activity: Feb 25 '12, 07:52 PM
Joined: Feb 23 '12
Location: New Jersey, US
-
The criteria is actually <>False which I don't quite understand, but it works like that. And I suppose now is a good time to figure out what it means.... -
I tried the non-SQL yesterday morning and it worked.
I didn't have the chance to try the SQL. I will give that a try Monday morning.
This won't be going into production until Tuesday, so I still have a chance to see what works best.
I will report back then and choose the best answer.Leave a comment:
-
No SQL as far as I know.
The code I posted is in the Field row of the last column of my query.Leave a comment:
-
This was suggested as a replacement for the end of my code:
I am going to give it a try tomorrow morning.Code:OR InStr([ChildBarcode],[Forms]![Policy_File_Inventory]![BarcodeNumber]),"")))
Leave a comment:
-
I was trying not to write a book, and I'm not sure what exactly you need to know, but here's everything I know:
There's only one table in use here.
There's an AutoID, BoxBarcode, and FileBarcode for each record. Some records have a ChildBarcode. A few records have multiple barcodes separated by a comma and space in the ChildBarcode field.
I'm pretty sure the fields are text.
There's a query with the AutoID, BoxBarcode,...Leave a comment:
-
How do I return search results for a field with multiple values?
I'm using Access 2002.
I have a query field set up that references a form, Policy_File_Inv entory, that has an unbound field, BarcodeNumber.
The form has several options related to the BarcodeNumber field. I am interested in what happens when the fourth option is selected. (The first and second selections work fine as is. The third option just displays all records.)
...Code:IIf([Forms]![Policy_File_Inventory]![Frame4]=1,[BoxBarcode]
No activity results to display
Leave a comment: