Hello,
I thought this would be easier but as I got to work on it I realized I had no clue how to do it.
I have a tblOrders that is generally updated every day with new orders.
In said table are two fields: DateAdded and DateDelivery.
My idea is to allow the user to print a report by specifying the date for either of the fields and grouping the data in the following fashion (with data stored in other tables), so that the report looks more or less like this:
Order#1(<- this doesn't have to be OrderID)
Date(either Added or Delivery, depending on the criterion used by the user)
Customer: John Smith Address: Maple Drive, x
Items: 1x screwdrivers
2x steel bars
2x whatever
Phone no.: 1234456789
Notes: deliver to colleague Frank Johnson if asked.
Total due: 25€
------------------------------------------------------------------------
Order#2
and so on..
Any ideas how to do this?
I thought this would be easier but as I got to work on it I realized I had no clue how to do it.
I have a tblOrders that is generally updated every day with new orders.
In said table are two fields: DateAdded and DateDelivery.
My idea is to allow the user to print a report by specifying the date for either of the fields and grouping the data in the following fashion (with data stored in other tables), so that the report looks more or less like this:
Order#1(<- this doesn't have to be OrderID)
Date(either Added or Delivery, depending on the criterion used by the user)
Customer: John Smith Address: Maple Drive, x
Items: 1x screwdrivers
2x steel bars
2x whatever
Phone no.: 1234456789
Notes: deliver to colleague Frank Johnson if asked.
Total due: 25€
------------------------------------------------------------------------
Order#2
and so on..
Any ideas how to do this?
