adding together the contents of the same field from various records
Posted 21 March 2012 - 09:36 AM
Sometimes, I have up to five records with the same invoice number and date, but different work dates, hours worked etc as several days may be on one invoice.
I want to create a field that adds the end total cost of each field that shares the same invoice number but am struggling.
I would also be interested to know if it is possible to make FM stop asking for a "date paid" if an invoice has not been paid. I tried to attach a copy with false names to demonstrate but this website wouldn't allow me to.
If anybody has any advice, I would be extremely grateful.
I have an idea!
Posted 21 March 2012 - 10:20 AM
tried to attach a copy with false names to demonstrate but this website wouldn't allow me to.
Zip your file and try again.
Posted 26 March 2012 - 01:16 PM
Posted 26 March 2012 - 03:53 PM
Posted 31 March 2012 - 01:26 PM
When I am checking bank statements and older invoices, I can easily find the information needed by searching for the invoice number. If there was a problem on a particular day, I can also very easily see who was working.
Wouldn't having each entry from one timesheet mean that each record would have to have many more fields to accommodate what could be seven shifts? Would that be what you would do?
I have been wondered whether an IF STATEMENT could be used?
Posted 31 March 2012 - 02:42 PM
No, because one invoice may contain several days all worked by the same employee.
That's precisely why the answer should be yes. Have a look at the attached file - hopefully it will all become clear.