I have a form named frm_ customer_record which includes the fields:
Company name (c_name)
Value of order (value)
Cost of order (cost)
At the moment it just lists records no filters.
The results I would like are grouped by the company name and filtered by the category which is controlled by a list box.
The results on the form, for each company name and filter, would include a total order value and a total cost value.
Also, when launching the form I would like the user to input a date range (from date) and (to date) so the results would also relate to the date range. If the input dates could also appear in the form (as text) that would be a bonus.
Any help would be appreciated. Thank you.