question on select statement

kavya · Sep 19, 2001

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

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

Thanks

Nancy2 · Sep 19, 2001

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

Fred · Sep 19, 2001

The correct syntax would be:

Code:

sSql = &quot;select MembersShipId from LookMembrShip
  where
  MemberShipCode = '&quot; & Me.PriorExamAuthority & &quot;'&quot;

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.

kavya · Sep 19, 2001

Thanks guys

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!

question on select statement

kavya

Programmer

Nancy2

Programmer

Fred

MIS

kavya

Programmer

Similar threads

Part and Inventory Search

Sponsor