Hello,
I am new to using QBF's. I always went in the query and entered the Criteria. However, I am leaving the database I created to people that are pretty much DB dumb. So I am creating a QBF for them to generate the required query to generate the correct report.
The problem is multifaceted.
First off, I have an employee that is attending the conferance. He is also allowed two family members that we will pay travel to attend. So I have to initial criteria of event date and event location to give me all the emploees that are attending an event.
Im good up to there. The Finace office requires that the family members be put on different types of travel vouchers depending on age. For example, family member (FM) 1 is over 18 goes on one type, if FM1 has a child (FM2) under 18 it is another type, and if FM1 and FM2 are under 18 yet a third type.
The easy way to do this is to run three seperate QBF's to generate the three queries needed.
Is there anyway to do this off of one qbf?
Thanks