Search results

I am trying to populate a txtBox on the SubForm of a Form, Using a Set Value Function = DlookUp function. The DlookUp Function searches for a value in the table and compares it to a value of another txtBox of the subform . The problem is: Using the Left Switch on Mouse works fine, txtBox is...

I have two tables, Orders and Sales. Product Description is common to both tables. I am running the following query; SELECT DISTINCTROW Orders.ProductDesc, Sum(Orders.quantity) AS OTotal, Sum(sales.Quantity) AS STotal FROM Orders INNER JOIN sales ON Orders.ProductDesc = sales.ProductDesc GROUP...

I am a new member, not experienced in acces. I am 76 Years Old and trying to learn something about Access. I spent must of my proffessional life designing Automac Machinnery for different types of industry. Well familiar with Auto Cad, Inventor, and LISP programing, some knowledge of Basic, VB...