Solved

VB Access SQL question

Posted on 2016-10-05
2
51 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Date 6 34
Display SQL maintenance plan SQL Code 3 43
Need a solid Expert on this Group By Query Syntax Help. 3 51
Menus 6 49
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 earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

740 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