id like to say that was useful, but errr I have no idea.
I need to be able to get a formula or something that will look at the account number and say 1 if it is the first and possibly only payment, and 2 if there is a second occurrence of the account number, 3 for the third etc.
the rest I...
Hi All,
only started poking around with access a couple of weeks ago as I was unable to find a way to do something in excel. I am trying to sort out a payment reconciliation sheet where I can show all payments received against a contract number, only problem is the payments are only identified...