Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VB Access SQL question

Posted on 2016-10-05
2
Medium Priority
?
63 Views
Last Modified: 2016-10-05
What is the correct syntax for this:

 Set rs_PG1 = CurrentDb.OpenRecordset("SELECT * FROM [ProductGroup] WHERE [Language] = "ENGLISH"")

"ENGLISH" is just a constant value.
0
Comment
Question by:Tony Crisafi
  • 2
2 Comments
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 2000 total points
ID: 41830297
try WHERE [Language] = 'ENGLISH' then the double quotes
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 41830302
if English is defined elsewhere as a string constant or variable then
[Language] = '" & ENGLISH & "' then the double quotes
i.e. single double & ENGLISH & double single double
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question