waylander32
Registered User.
- Local time
- Today, 00:38
- Joined
- Oct 20, 2010
- Messages
- 20
Please help
I want my DB so that 1 report can be filtered easily by any user with as little interaction as possible so I have a form that has combo box's linked to differant fields the idea being that an operator can select for exmple a project code and on the press of a button the report is filtered by that project code.( The report is linked to a query just to bring all the field together )
No problem with the set up and operation of this untill I did the daily report
The combo box looks at a field called run date if they select for example the 25 oct 10 no problem if they select 2 nov 10 the report is blank ( The date must exist to be in combo list)
I have checked the report without any filters no problem also tried entering in as a crietera in the query no problem.
The only pattern I can see is if the day is less then 12 so I thought may be due to locational settings.
I have checked the field properties in the combo box, report and the query all set to the same ie medium date. I'm now stuck.
The answer is probably looking at me laughing can some one help please?????
I want my DB so that 1 report can be filtered easily by any user with as little interaction as possible so I have a form that has combo box's linked to differant fields the idea being that an operator can select for exmple a project code and on the press of a button the report is filtered by that project code.( The report is linked to a query just to bring all the field together )
No problem with the set up and operation of this untill I did the daily report
The combo box looks at a field called run date if they select for example the 25 oct 10 no problem if they select 2 nov 10 the report is blank ( The date must exist to be in combo list)
I have checked the report without any filters no problem also tried entering in as a crietera in the query no problem.
The only pattern I can see is if the day is less then 12 so I thought may be due to locational settings.
I have checked the field properties in the combo box, report and the query all set to the same ie medium date. I'm now stuck.
The answer is probably looking at me laughing can some one help please?????
