Simple Query why not working?

[nval005]

arrrrrrrrgh that's weird...that didnt fix it... i'm going to cry !!! arrrrrrrrrrrrrrrgh

same issue, query is working, but the rs.recordcount shows 0

any idea why its failing?

 

[nval005]

hi Drake,

i tried what you advised and still the same, it gives me 0 records

 

[nval005]

Hi Drake, thanks so much for your help ! I think I'll give it a rest, im sure solution/ideas will pop out when I go to bed or something

have a good weekend!!!

 

[DCrake]

Your query that you are attempting to count has no fields in it. So how the hell is it going to count them. You need at least one field to count. Instead of going down that route why not simply do a DCount() on the source table for the date range.

 

[nval005]

hello, I'll keep trying and post the solution, I need to use recordset because I need to iterate on the records to create an XML file. wish me luck!

I tried Dcount unfortunately its not the one I need...

 

[nval005]

hahahahahaha how silly of me... found the problem

Dim stdate, enddate As String
stdate = Format(CDate(Me.txtBatchStartDate.Value), "MM/DD/YYYY")
enddate = Format(CDate(Me.txtBatchEndDate.Value), "MM/DD/YYYY")

it was "DD/MM/YYYY"

recordset works perfectly now, gives me the correct data.

now I can sleep peacefully...for now thanks David