I am using Access.

I want a  query to run based on the current system date.

I have tried to get this to work based on your examples and cant figure out what is wrong. 

Please advise.

Thanks

Select * from SalesOrderLine Unoptimized where timemodified >= {fn Curdate()}

Expected lexical element not found: <identifier> (#11015)

This will display modified rows from 15 minutes ago:

Select * from SalesOrderLine Unoptimized
where timemodified >= {fn TIMESTAMPADD(SQL_TSI_MINUTE, -15, {fn NOW()})}

While this will display modifed rows from today:

Select * from SalesOrderLine Unoptimized
where timemodified >= {fn CONVERT({fn Curdate()}, SQL_TIMESTAMP)}

See: How are dates formatted in SQL queries when using the QuickBooks generated time stamps? for more.