Need Help for correcting a SQL Query

[Naveed Raza]

Hi All,

i am trying to extract data from PUR REG CO Table by writing below query but its displaying nothing..

anyone plz can rectify this..

Please Login or Register  to view this content.

what my condition is creditdt should be blanks & rejdate should be (14/06/2013 & as well as blanks) & trtype should be (does not end with R)

[xlbiznes]

Hi,

Did you try executing this query with only 1 condition for [creditdt]="" ?

[alansidman]

Change your blanks "" to Null. Access doesn't recognize "" as Null but as a string with nothing displayed. When you use a wildcard, you need to precede it with a Like or Not Like.

Is your field for rejdate text? If not, then remove the quotation marks, and replace them with hash tags # so the where statement looks like this:

Please Login or Register  to view this content.

[Naveed Raza]

Sir

Thanks for quick response..

i tried whatever statement u have given but its displaying nothing...

[Naveed Raza]

Thank you for your support sir

i changed that statement with below statement and its working fine...

Please Login or Register  to view this content.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Naveed Raza]

Sir one more thing

everyday i am manually changing the date, is there any way so that query can take current date or yesterday day....

[alansidman]

Instead of inputting the date manually, change it to Date()

This is equivalent to the Today() function in Excel.