Between dates

[deanvilar]

Hello Gurus ... what seems to be the problem of my SQL query? thanks in advance.

SELECT *
FROM XFEMainTable
WHERE (XFEMainTable.memEndDate BETWEEN forms!PERSONNELINFO_PRINTMODULE!txtFromDate And forms!PERSONNELINFO_PRINTMODULE!txtToDate)
ORDER BY XFEMainTable.memNo;

 

[pr2-eugin]

You have to tell us what the problem is. What is happening, what is not happening, what is given as a result or what is not given as a result?

 

[deanvilar]

Hello Paul ... it returns all the data in the table .. it does not filter the dates as BETWEEN ..

 

[jdraw]

Did you get an error message? Is your Form open-- it must be open and valued to get proper substitution in your SQL. More info please.

 

[deanvilar]

no error messages ... it just returns all the data in the table ...

 

[vbaInet]

That's peculiar! I believe the dates returned from txtFromDate and txtToDate are the minimum and max dates in your table. And it's possible that those dates are misinterpreted.

By the way, that's a pretty clear pic in your profile.

 

[deanvilar]

oh thanks! ha ha

 

[vbaInet]

Most people put avatars.
Have you checked the values returned by those textboxes?

 

[pr2-eugin]

Most people put avatars.

Some keep their identity a secret

 

[vbaInet]

Such people should be banned from these lovely forums!

 

[deanvilar]

am trying to give a check once more ... I think people here should open up a bit .. =D

 

[vbaInet]

... I think people here should open up a bit .. =D

We're already doing that... by providing solutions. Yay!!

 

[deanvilar]

open up in a different way =)
btw STUPID ME ... I made the field of the dates as TEXT damn! thanks for your replies .. now its ok =D