Search results

How would I do this? I have a table that is like this: ID | OrderID | ProdID The ID is unique. What happens is there could be an order for several different products, like this on the same order: ID | OrderID | ProdID 1.......001..........24 2.......001..........17 3.......001..........19...

I have a Combobox so the enduser can search and select items for the form below it rather than clicking the arrows for Next/Previous. However I have an issue with DLookup queries. My Combobox is called 'F_ComboBox' (I use F_ in my forms to indicate it's a form textfield and not from a table)...

How do I repeat rows on a form like the "Multiple Items" form, for each row in that table? I'm wanting to create my own blank form with specific fields/queries but repeat it for each row - just not sure how. Thanks.

Yep, it's a number field also.

Still can't get it to work, remember that ProdID is a TextBox in the form. Here's what I tried (the form is open to ProdID '2')... =DSum("QtyAdd","Orders","ProdID = 2 AND StockItem = Yes AND Arrival = Yes")-DSum("QtySub","Output","ProdID = 2 AND Dispatch = Yes")

Just a quick one, I have a TextBox in my form, that currently has this DSum in it: =DSum("QtyAdd","Orders","ProdID")-DSum("QtySub","Output","ProdID") (ProdID is another TextBox in the form, QtyAdd is from the Orders table, and QtySub is from the Output table) I'm also wanting to query it with...

Here's what I'm trying but with no luck: SELECT Sum([Orders.QtyAdd]-[Output.QtySub]) AS Expr1 FROM (Products INNER JOIN Orders ON Products.ProdID = Orders.ProdID) INNER JOIN [Output] ON Products.ProdID = Output.ProdID WHERE (((Orders.StockItem)=Yes) AND ((Orders.Arrival)=Yes) AND...

Sorry, I mean if Forms follow this, like Form.Textfield. So I can do something like: Order.ProdID = Form.TextField :)

As an example, I have 2 separate queries: SELECT Orders.QtyAdd FROM Orders WHERE Orders.ProdID = 1; SELECT Output.QtySub FROM Output WHERE Output.ProdID = 1; What code do I use to subtract these 2 queries? And also, where it says .ProdID = 1; what is the variable so it picks the ProdID from...

Hi guys, I'm new to Access except using it years back but much has changed from the 2000 version to the 2007 version - it's slowly coming back to me though, as it's mostly just an interface change. Although I'm highly experienced in SQL (mySQL) and database design / structure from being a Web...