Search results

Ok, I just ran the query as in your post: WHERE [Sup1inv]>=[Ordqty] AND [OrderID]=[555] and unfortunatly its doing the same thing. see, on order 555 widget1 can not be ordered from suplier1 becasue there are not enough, but widget2 on order 555 can becasue the supplier has enough. When I run...

Thanks for the reply. So, if I understand correctly, I need to have the query look at each order # one at a time, then move on to the next order #. What would be the command to make the query check order 555, then move to order 556? Thanks again for the help, I really appreciate it. Eddie

oK, sorry for the vagueness. What i mean is I want it to return records where [Sup1inv]>=[Ordqty] I know how to do this query, the problem I am having is the query does not know that both lines for order # 555 are the same order with 2 different items. When i put the critera in for above it...

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

Thanks for the response. Your reply sounds good to me. I am in the middle of reading Using Microsoft Access 2002, its about a 1500 page book. I have a very food understanding of tables and their relationships. Where I am seriously lacking is in queries and VBA. I did have to make a primary...

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