Query behind form not working...

  • Thread starter Thread starter Gina Whipp
  • Start date Start date
G

Gina Whipp

1. If (DLookup("[BillByID]", "tblBillBy") = 1) And Me.txtTimeDecimal >= 1
Or Me.txtTimeDecimal <= 7.99 Then

2. Me.txtRate = DLookup("[PerHour]", "qryClientBillingRate",
"[ClientID] = form.cboClientID")

End If

HELP! Line 1 is not working, I tried

If (DLookup("[BillByID]", "tblBillBy") = 1) And Me.txtTimeDecimal Between 1
And 7.99 Then

and that doesn't work either. It updates a field on a form, Me.txtRate.
The amount is different, the lines based on minutes < 0.98 and on days >8
work just fine but I need to calculate the hours should you enter hours
instead of minutes or days. Can anyone tell me what I am doing wrong?

As always... THANKS!
Gina
 
Back
Top