incorrect syntax near the keyword 'between'

[gaba]

Hi, I'm working on an Access Project (front end) with MSDE (back end). I've
created a search form to open reports. I need to create a Where clause to let
the user enter two values: between ---- And ----
I'm getting an "incorrect syntax near the keyword 'between'.

part of the code goes:
Dim varWhere As Variant
'Initialize to Null
varWhrere = Null

If (Me![SSForms] = 1) Then
DocName = "WWDW_Sample_Submission"
If Not IsNothing(Me.StartID) Then
'.. build the predicate
varWhere = "[LabID]=" & "Between " & Me.[StartID] & "AND " & Me.[ToID]

End If

If (Button = "print") Then
DoCmd.OpenReport DocName, A_NORMAL
Else
DoCmd.OpenReport DocName, A_PREVIEW, WhereCondition:=varWhere
End If

Any help will be greatly appreciated,

 

[Douglas J. Steele]

You don't use = and Between together.

varWhere = "[LabID] Between " & Me.[StartID] & "AND " & Me.[ToID]

 

[gaba]

Thanks so much Douglas! As you can see I'm learning.
Can I bother you with one more question? How can I add the order so when
opening the report is by LabID asc?
Thanks in advance
--
gaba

You don't use = and Between together.

varWhere = "[LabID] Between " & Me.[StartID] & "AND " & Me.[ToID]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi, I'm working on an Access Project (front end) with MSDE (back end).
I've
created a search form to open reports. I need to create a Where clause to
let
the user enter two values: between ---- And ----
I'm getting an "incorrect syntax near the keyword 'between'.

part of the code goes:
Dim varWhere As Variant
'Initialize to Null
varWhrere = Null

If (Me![SSForms] = 1) Then
DocName = "WWDW_Sample_Submission"
If Not IsNothing(Me.StartID) Then
'.. build the predicate
varWhere = "[LabID]=" & "Between " & Me.[StartID] & "AND " & Me.[ToID]

End If

If (Button = "print") Then
DoCmd.OpenReport DocName, A_NORMAL
Else
DoCmd.OpenReport DocName, A_PREVIEW, WhereCondition:=varWhere
End If

Any help will be greatly appreciated,

 

[Ofer]

Open the report in design view, in the menu bar select view > sorting and
grouping, Select the field you want to sort by and then select Asc

--
I hope that helped
Good luck

Thanks so much Douglas! As you can see I'm learning.
Can I bother you with one more question? How can I add the order so when
opening the report is by LabID asc?
Thanks in advance
--
gaba

You don't use = and Between together.

varWhere = "[LabID] Between " & Me.[StartID] & "AND " & Me.[ToID]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi, I'm working on an Access Project (front end) with MSDE (back end).
I've
created a search form to open reports. I need to create a Where clause to
let
the user enter two values: between ---- And ----
I'm getting an "incorrect syntax near the keyword 'between'.

part of the code goes:
Dim varWhere As Variant
'Initialize to Null
varWhrere = Null

If (Me![SSForms] = 1) Then
DocName = "WWDW_Sample_Submission"
If Not IsNothing(Me.StartID) Then
'.. build the predicate
varWhere = "[LabID]=" & "Between " & Me.[StartID] & "AND " & Me.[ToID]

End If

If (Button = "print") Then
DoCmd.OpenReport DocName, A_NORMAL
Else
DoCmd.OpenReport DocName, A_PREVIEW, WhereCondition:=varWhere
End If

Any help will be greatly appreciated,

 

[gaba]

Thanks so much Ofer,
Everything working!
--
gaba

Open the report in design view, in the menu bar select view > sorting and
grouping, Select the field you want to sort by and then select Asc

--
I hope that helped
Good luck

Thanks so much Douglas! As you can see I'm learning.
Can I bother you with one more question? How can I add the order so when
opening the report is by LabID asc?
Thanks in advance
--
gaba

You don't use = and Between together.

varWhere = "[LabID] Between " & Me.[StartID] & "AND " & Me.[ToID]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hi, I'm working on an Access Project (front end) with MSDE (back end).
I've
created a search form to open reports. I need to create a Where clause to
let
the user enter two values: between ---- And ----
I'm getting an "incorrect syntax near the keyword 'between'.

part of the code goes:
Dim varWhere As Variant
'Initialize to Null
varWhrere = Null

If (Me![SSForms] = 1) Then
DocName = "WWDW_Sample_Submission"
If Not IsNothing(Me.StartID) Then
'.. build the predicate
varWhere = "[LabID]=" & "Between " & Me.[StartID] & "AND " & Me.[ToID]

End If

If (Button = "print") Then
DoCmd.OpenReport DocName, A_NORMAL
Else
DoCmd.OpenReport DocName, A_PREVIEW, WhereCondition:=varWhere
End If

Any help will be greatly appreciated,