Ive finaly managed to get the most of the QBF part of my db working and now im a little stuck, (well not stuck just not sure what to do).
I can only search on 2 crieteria it wont allow me to search in employeeID, any ideas?
Once i have the data im after how do i go about getting a grand total for all the items purchased?
I have a from "QBF_Form" which allows me to enter and search by ClientID, Employee, and Date, The "QBF" works fine i can enter an order date and a clientID and it will put that order up via a query, i put another button on the "QBF_Form" that allows me to open a report based on the QBF_Form Results.
What i want to know is the following:
Is there a way so that when i enter the search criteria in the "QBF_Form" instead of it bring up a query window it opens the report straght up with the details in.
sample DB attached with what i got so far
Last edited by Icerat; 07-22-04 at 08:04.
Reason: Typos :)