Solved

VB Access SQL question

Posted on 2016-10-05
2
56 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 500 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

Automating Terraform w Jenkins & AWS CodeCommit

How to configure Jenkins and CodeCommit to allow users to easily create and destroy infrastructure using Terraform code.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

628 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