K guys i m extremely sorry for wasting your time. Even too gave up.

Thank u for helping me to solve my issue.

Sachin

It is Date/Time datatype

Hey

SELECT ID, SiteName, DRCNum, TypeID, Point, [Time], CardNumber, FormatName

FROM TransactionLog

WHERE (ID > 5)

above...

Hey parkin,

Its showing error for where clause and even then if i give ok space will be automatically inserted.

I checked its twice

I doubt whether i can use where clause in...

Anyone of u please please help me guys. I have to deploy this today:crying:

Please find the attchment

There was an error displaying the preview.

------------------------------

ADDITIONAL INFORMATION:

Invalid use of '.', '!', or '()'. in query expression 'TransactionLog. TIME > DATE ()'. (Microsoft JET Database Engine)

still I m getting...

Thank u guys. I will work with your logic and revert back to you 🙂

Hi please find the attachment

Is it becoz ms access database doesn't support getdate() function or something like that

Hi i have uploaded attachment.

Its showing error bcoz i have used getdate() function.

Error in WHERE clause near 'TIME'.

Unable to parse query text.

----------------------------------

This is the error i m getting. If i use where clause it shows error 🙁

Thank you, I will try your query and revert back to you another 5 mins

Hi I have used query in my source but how to write query to fetch rows containing todays date only.

I have used below query

SELECT TransactionLog.*

FROM...

Hi, Phil Parkin and da-zero

Thanks for your suggestions but as told by da-zero i can't fetch all the rows then deviate rows containing todays date to another component because that...

Thank you both Gopi and coldcoffee for your answers.

sachin