Search results

Suppose there are two tables - customer and product. Also available is customerproduct (linked table containing customers and the products they bought).i want to design a query which will list products NOT bought by a customer i.e. each customer will be listed with products not bought by him...

(SELECT Aviator.Prefix, Aviator.Number, Aviator.DateOfSeniority, Year([DateofSeniority]) FROM (Aviator INNER JOIN AviatorCourse ON Aviator.ID = AviatorCourse.AviatorID) WHERE (((AviatorCourse.CourseName)=9) AND ((Year([DateofSeniority]))=2007)))) LEFT JOIN (SELECT Aviator.Prefix...

Here is the result of a query Name ItemBought Tom Box Tom Candle Tom Pen Bob Box Bob Pen A form is used to Select name (combo box) and items bought (check boxes). In this case, the form has a single combo box and three check boxes...

I need to convert the following filter expression produced by access in a query to VBA (Lookup_EquipmentID.EquipmentList="A" AND Lookup_EquipmentID.EquipmentList="B")

Hello Access Gurus, I want to assign the text of a textbox (in a form) to a particular row in a query. For example, suppose the query has the following output EmployeeID(key) LastPosn ------------------- ----------- 12356 Manager 14567 CEO...

I have a list of employees with their category promotion dates (A category is better than B and so on. NA implies that the person is not yet categorised) ID Category Date -- ---------- ----- 1 D 1/3/12 2 C 1/2/86 1 C 2/4/13 2 NA...

I have a table (say table1) like this in Access 2013 userid Category Date ------ -------- ---- 1 A 1 MAY 13 1 B 2 MAY 14 2 B 1 MAY 12 3 NA 1 MAY 15 1 D 1 MAY 16 2 A 1 MAY 13 4 NA 1 MAY 14 5 C 1 MAY 12 i intend to design a...