SQL syntax 1

[benwah]

Hi I am using a query to select postcodes that begin with a particular combination (eg UB1, UB2 W5, W6 etc). The user, via a form, selects which combo it will be. How will the SQL code look? This is what i have at the moment but it is obviously wrong...

SELECT DPPF.refnum
FROM DPPF

WHERE (((DPPF.DateClosed) Is Null) AND ((DPPF.AppPostalCode) Like "[Forms]![frmWhatDates]![enddate]*&quot)

ORDER BY DPPF.DateClosed;

It doesnt like the "[Forms]![frmWhatDates]![enddate]*" part and I know it must be a simple error in my syntax but i have no experiance using SQL so i have no idea!

Thanks in advance
wah

 

[benwah]

sorry this part:

"[Forms]![frmWhatDates]![enddate]*"

should read:

"[Forms]![frmWhatDates]![postcode]*"

still doesnt help any though!

wah

 

[tlbroadbent]

You need to remove the quotes (&quot around the control name and add the concatenation operator (&).

WHERE (((DPPF.DateClosed) Is Null) AND ((DPPF.AppPostalCode) Like [Forms]![frmWhatDates]![enddate] & "*&quot)
Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[benwah]

thanks terry that worked a treat!

wah