6 replies
by heartyguffaw
The problem may not be with the report, but with the query or the form dialog.
In the Northwind DB, the query criteria is based on the "Sales By Year Dialog" form. If you are doing something similar, to troubleshoot your problem, try this:
- Make sure your form dialog "Modal" setting is "No"
- Open the form and put in your dates
- Leaving the form open, run the query
The query should display only the dates your form has in it.
If you get the the same error message as before, itcould be format of your form dialog date fields or something in the query criteria referring to the form.
by shanghai sam
by timfox
If you are using a crosstab query, your column headers may change depending on whether you are including nulls in your recordset result. That's all I can think of, in terms of how this error would be caused by a change in the dataset.
Have you tried troubleshooting this by testing the query with changes to your filter etc?
by shanghai sam
by timfox
If you are using a crosstab query, your column headers may change depending on whether you are including nulls in your recordset result. That's all I can think of, in terms of how this error would be caused by a change in the dataset.
Have you tried troubleshooting this by testing the query with changes to your filter etc?
by dalesmp
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending