No. I was suggesting that you define calculated fields in your query that
would hold the parameters.
Just for future reference, "Date" is a bad name to use for a field. There's
a built-in function named "Date" and having that as a field name can lead to
problems unless you handle it just right. I suppose it's too late to rename
that field? We can work around it if we have to.
No. Those are elements of the SQL statement. It's not a formula, it's the
"SQL View" of a query. What I posted was an example.
"MyTable" was just the name of the table I used for my example. "SELECT
MyTable.*", in SQL, means "select all the fields in the table named
'MyTable'".
I think we'd better approach this from a different angle. You say your
report is based on a query that has date parameters. Please open that query
in SQL View, and copy/paste the SQL statement into a reply to this message.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)