Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

question on select statement

Status
Not open for further replies.
kavya

kavya

Programmer
Feb 21, 2001
83
0
0
US

ssql = "select membersshipid from lookmembrship where membershipcode = " & Me.PriorExamAuthority


if me.priorexamauthority is a string then how would the syntax be.

Thanks
 
Sort by date Sort by votes
Not sure what you are using this for but you would need to add &"'" to the end to close off the string for the ssql variable


 
Upvote 0 Downvote
The correct syntax would be:

Code: 
sSql = "select MembersShipId from LookMembrShip
  where
  MemberShipCode = '" & Me.PriorExamAuthority & "'"

Since Me.PriorEamAuthority is a string, you must surround
it by single quotes.

This will only work if Me.PriorExamAuthority doesn't
contain any embedded single quotes.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Jaime_78
  • Locked
  • Question
DoCmd.OpenReport Hangs when user wants to select location of report to save to
Replies
2
Views
72
Jaime_78
Jaime_78
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
112
PizMac
PizMac
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
128
atadbitslow
atadbitslow
Bill6868
  • Locked
  • Question
Query Expression Question
Replies
3
Views
59
Andrzejek
Andrzejek
kmsohn
  • Locked
  • Question
Reservations prevent double booking on same date-Access
Replies
1
Views
64
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top