hi, i have the data stored to tables and have created the tables as per suggestions and input from access users.
i don't know how to retrieve this information in ways that will satisfy the end user.
the dockets/receipts i have entered using forms and stored in main docket and docket details now needs to be retrieved and marked accrued once it has been connected to an end of month budget and then marked invoiced once it has been paid against an invoice. Then it needs to not show up in future searches unless we are looking for paid or accrued dockets.
the problem i am having is making the end user look suit what is needed. 50 companies 30 different formats. some companies don't use addon's others don't use vehicle hours. some are material some are labour.
Do I do an query for each individual company? to make sure that the data that is being brought forward is only showing what is required for that company?
i am lost