Recent content by Wayne Jordan

Thanks plog. So how do I do that? How do I tell it nulls are OK? Does this mean I can do it with just one query? I do appreciate your post because I want to learn as much as possible. What you said makes sense. Basically I was saying I wanted everything from both tables that fits the criteria I...

Thanks sneuberg. As part of testing I tried query 1 alone without the Transactions.ID and it didn't work right but when I added it did, so obviously that is a key piece of evidence. I am now getting the results I want. Thank you very much. Thank you for your post CJ London.

I have had similar problems like this in the past but the old solutions don't seem to work here. This is an inventory database. I have two tables in this question, tlbIems and tblTransactions. tblItems lists all items in my database, i.e. boxes, bubblewrap etc. tblTransactions records when I...

Thank you very much. I rebuilt the query and made sure all the data came from tblOrderDetails and just asked for a sum of the qty Received from tblTransactions. Then I switched to SQL mode and changed the word INNER JOIN to LEFT JOIN and it gave me all I asked for but NULL for the Items that I...

Those tables were done in a spreadsheet for this post and they didn't look like that in excel. Let me type them out. tblOrderDetails Key ItemId OrderQty PO# 001 A 20 4001 002 B 20 4001 003 C 20 4001 tblTransactions Key...

I have a problem that involves null values that I do not know how to solve. I have the following tables: tblOrderDetailsKeyItemIdOrder QtyPO#001A204001002B204001003C304001 tblTransactionsKeyTransDateItemIDReceivedPO#0011/1/2014A1040010021/2/2014B2040010031/3/2014A54001 I also have a table...

Don't know what happened above. 2. My solution. I described the overall concept but not the actual formula. It was really more like, Sum of Received + Sum of all order details where the field "PO closed" = "no", i.e if the PO is still open count the outstanding qty, if closed don't count. Custom...

I figured it out. Actually, I learned two things. 1. Do a more complete job of describing my calculations. My

My db tracks consumable supplies for our warehouse. I have seen the light and now calculate qty on hand instead of storing that value in a table. I do the same with outstanding quantities on order. I also have a query that tells me when it is time to order. Or did. For each item I had the...

It was the column count property. Thanks Dave but the most I know about VBA is that the VB stands for Visual Basic. I don't even know what the A stands for. I have barely dabbled in SQL. So far I have been able to do basically everything without them. I do want to learn. Yeah, it may come...

I am sorry that I forgot to thank you earlier.

Yes, I do. I did not list all the fields of the query in my post. That was sloppy. The columns are numbered correctly, and the text box associated with column (3) fills properly. The box for column (4) does not. Thank you for taking the time to work with me on this.

OK, I am very confused. pbaldy, I tried what you sent in the link above and had mixed results. Here is more detailed information. I have tbl.Items with fields ItemId, Item, VendorID, VendorName, VendorAddress, VendorCity, VendorState, VendorZip, OrdQty, and OrdPrice. OrdQty is the normal...

Hello everyone, this is my first post here. I am fairly new to Access and it is my only programming experience. I don't know VBA and have used very little SQL. I am in charge of consumable supplies in our warehouse and have built a database to record inventory, create reports for orders etc...