Explain the use of where clause in ms access sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MS Access Interview Questions

Explain about the various features present in MS Access?

0 Answers  


Explain table queries and select queries. What are the main differences between the two?

0 Answers  


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

0 Answers  


Is microsoft access being discontinued?

0 Answers  


Where can I find microsoft access on my computer?

0 Answers  






What is the importance of ms access?

0 Answers  


How do you create a database using microsoft access?

0 Answers  


How to create software using microsoft access?

0 Answers  


Is access a good database?

0 Answers  


What are the different parts of a database application called in access?

0 Answers  


What type of database is access?

0 Answers  


Is microsoft access like excel?

0 Answers  


Categories