M
MRFannon
If I create a query in an Access Project, (with the datasource in SQL 2000),
and I prompt for a time range, (start and end time), it returns zero rows.
If, instead of prompting for the time range, I explicitly put the time range
in the query, it returns the correct rows. This is only a problem when the
database is in SQL Server, and the query is created in Access. If the query
is created in SQL Server, (Ent. Mngr. and SQL Analyzer), or when the database
is created in Access it works fine. Anything would be helpful. Thanks.
and I prompt for a time range, (start and end time), it returns zero rows.
If, instead of prompting for the time range, I explicitly put the time range
in the query, it returns the correct rows. This is only a problem when the
database is in SQL Server, and the query is created in Access. If the query
is created in SQL Server, (Ent. Mngr. and SQL Analyzer), or when the database
is created in Access it works fine. Anything would be helpful. Thanks.