What is the role of where clause in ms access?
No Answer is Posted For this Question
Be the First to Post Answer
Can you use microsoft access on a mac?
How do I create an access database from multiple excel files?
What is the purpose of ms access?
Explain relationships?
Does anyone still use microsoft access?
What is dao recordset in access?
What is a database in microsoft access?
What are the several file extensions in ms access?
What is a good replacement for microsoft access?
What is query in ms access?
How do you link data in access?
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