Hello everyone,
I'm working with Jet Essentials and I want to filter (cq look up) four things out of a database (FilteredIncident):
-a filter per week (hig_registratiedatum) date..date
-a filter on a customername (customeridname)
-a filter on when the incident was closed (date..date)
-a filter on the status (statuscodename)
Whatever I try to do, for example in the JFX function wizard (see printscreen) i get all the information out of the database FilterdIncident. 
Is there anyone here who knows what I cannot seem to solve? :o Thanks so much! :lol:
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Annelies,
As I do not have this table in my database, I cannot replicate your situation. However, I would at least try the following:
- Use an option-sheet to generate user-input on the filter values. Use NP("Eval";celladdress) to use the values in your report-sheet(s).
- Use an NL("Rows";"FilteredIncident";;"hig_registratiedatum";NP("Datefilter";$E$5;$E$6)) in D12? This assuming E5 and E6 hold the start- en enddates for the datefilter. Of course you can change this.
- NF's to retreive fieldvalues from the filtered records. For example NF($D12;"hig_registratiedatum")
Hope this helps a bit.
Best regards,
Gerard
Please sign in to leave a comment.