Search results

To summarise, you have a list of parts, belonging to a single order, but when you pull the data in it wants to go as one item, one order. Ie, you want a one to many relationship, but in fact you get a one to one. Looking at tblOrderDetails you are using a unique record ID of OrderDetailsID...

Sounds quite normal. (I used to get this a lot) When I investigated, it was because there were no records which satisfied the query. Another other effect is when you get a huge number of results. In this case the query does not have limitations, so it provides all possible combinations! Some...

I suspect I have missed the point of the question. As I read the question you want to express the sum of the time elements for each specific course. This is very simple to do. A simple query on the table, Add both fields to the query Press the sum button, (The sigma symbol) Use "group by" for...

Thanks for example. Essentially this copes with the problems. As yet I have not gone through it fully but this example produces a table. I wish to do this as a query only. Looking at the method, it does not seem easy to change it to operate as a query. Is this possible, or do I have to work...

Sounds like the open combo box is fine. It is the other you have problems with. If both are from the same table, then normally you would be accessing the a single record, in which case a standard text box will display the contents of the record ascossiated with your selection in the combo box...

Thanks for reply. I have worked through your reference, and this is pretty much what I had done. Where I come unstuck is the point where "some recursive VBA code" is required. The structured part list is working well. But to get it to a single level "purchasing list" is the problem. Obviously...

I have been trying unsuccessfully to find a reference or example to show how to do a BOM. I understand it is a wellunderstood problem, but... Specifically, I have table with AssemblyNo, PartNo, Quantity. Problem is that a Part Number may also be an assembly with its set of parts, and this may...