dcount

[mikeba1]

i have a form with two dates and a command button to execute the following dcount
it does not give me the same results as whenj i run a query directly

is my syntax wrong

x = DCount("roombookings.status", "roombookings", "(RoomBookings.Status)='B'AND ((RoomBookings.Appdate) Between #" & [Forms]![frmallrecords]![sd] & "# And #" & [Forms]![frmallrecords]![td] & "#)")

 

[dhookom]

This is probably do to your date format. You need to make sure the dates are m/d/y.

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

have changed format on the form to mm/dd/yy but the results are the same with format dd/mm/yy

 

[dhookom]

Try hard-code in some dates using the debug window:

?DCount("status", "roombookings", "Status='B' AND Appdate Between #11/1/2010# And #11/30/2010#")

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

thanks, problem solved, was not converting date correctly