Between two values

[primagic]

I am trying to write some vba that will check if a value is between to fields, however the code below comes back with a compile error: expected then or goto after the between statement. I am using sql as a backend

If Forms!frmLeads!frmLeadsSubForm.Form!MortgageSize Is Between Forms!frmTest!Betwee" And Forms!frmTest!End Then

 

[TheAceMan1]

How are ya primagic . . .

[blue]If Forms!frmLeads!frmLeadsSubForm.Form!MortgageSize >= Forms!frmTest![purple][b]LoControlName[/b][/purple] AND _
   Forms!frmLeads!frmLeadsSubForm.Form!MortgageSize <= Forms!frmTest![purple][b]HiControlName[/b][/purple] Then[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[primagic]

Thank you AceMan,

Works perfectly. Would the code be the same if I need to query between two times? Like Between 9.00AM and 12:00PM (Midday)

 

[TheAceMan1]

[blue]Would the code be the same if I need to query between two times? Like Between 9.00AM and 12:00PM (Midday)[/blue]

That depends on wether your time field is type
[ol][li]DateTime [blue]with[/blue] a date.[/li]
[li]DateTime [blue]without[/blue] a date.[/li]
[li][blue]Text/AlphaNumeric[/blue][/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]