Search results

Hello all, I need help with making a query this will check the OrdQty for all items in a specific order against the Sup1inv field, then if supplier 1 can not fill the order have it check against Sup2inv field. Here is an example of the data im working with Order# Item# OrdQty Sup1Inv...

Hello All, I am new to the forum and access as well. I have already gotten a bit of help on here and I am grateful that you guys share the knowledge. I have a 2 part question and the first is kinda long so here goes. Can this be done in access? I have an eCommerce business and every day I...

Hello, I am using this thread in the criteria field in a query: "*" & [Forms]![NameOfYourForm]![B1] & "*" but when i run the query i am getting an error message stating: This expression typed incorrectly, or is too complex to be evaluated. any idea why i am getting this error in this given...

Hello All, I am new to access so this might be a stupid question but here goes. I am making a new database for my orders (which I download from my eCommerce software in the form of a CSV file). The Problem I am having is that my Order numbers are unique and that is what identifies the orders...