How can I give discount condition in a sales table in MS
Access?
Answer / lokesh ghildiyal
Using IIF function condition in access we can make several
conditions for sales.
Is This Answer Correct ? | 2 Yes | 1 No |
What is a query in access?
Explain about relationships and look up fields?
What are access modules?
What would happen if the both source and destination have the same name?
Will ms access be discontinued?
What is the use of ms access 2007?
What is access runtime?
What can I use microsoft access for?
Is ms access still used?
State the criteria which a trusted publisher should meet before adding him?
Would you like to easily automate your MS Access database through menu driven selections?
I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a