Reports not sorting

[gpurger]

I have a form that the user can select a report using options through 'group options'. These then open up the report using specific queries. One report many queries.
The queries are the same except for the filter criteria.
I created 1 query then copied the rest and adjusted the criteria. I am sorting on a numerical value.
All the queries sort fine in preview but not in the report except for 1.
If I copy this query and alter the filter criteria it solves the problem.

I want to know what am I missing.
All this is done using VBA.

Cheers


Gordon

 

[DocNice]

I'm a bit lost on your question, but I do want to know, if everything is the same except for one changed criteria, why don't you set that as a variable and have only one query?

 

[gpurger]

Hi,
The options are:
All records or Sub-system (from listbox) records
and
Date filtered(formula on query)
and
Preview or Print

The report works if I select anything AND Date filtered but not if I miss out the date filter.
All queries sort when previewed so I think it is my VBA code.

The reason I call seperate queries is because I can not get the variable option to work. One step at a time.
Can not post code as this PC does not have access and am away from normal site. Try later.

Cheers

Gordon