Search results

I have a multi select list box. I copied the corresponding code from a functioning database. It runs correctly in the new database until LOCNCODE. I then get an "input box" to enter the LOCNCODE. LOCNCODE should be pulled from the list box. I have tried removing the statement, but then the...

I need to filter or query my records based on a text field containing a certain string. Basically, I have an item description. I need to return only those records that contain "screw" or "nut" or whatever else I want to enter. Thanks!

I have three queries. One that contains ALL items that have been received (qryLastRCTDate), one that has all items that have been shipped (qryLastShip), and one that contains the unmatched records (qryNoShip) i.e. the ones that have been received but never shipped. Ultimately, I would like to...

I am creating queries based on tables linked to our accounting package. I have a query for which the user will need to choose parameters. I need to have a lookup feature of some sort for this criteria using a field in a query. I am thinking a list box. I know how to add a parameter based on...

Hi, guys. I have a query in which I only want to return the most recent records until the sum matches a particular field. For example, I have 7 of an item on hand. I want the query to return only receipts for the last 7. Is this possible? Thanks!