I am trying to create an access database to perform some calculation in a query but am getting a error. The formula is:
The second if statement seems to be the problem. I've attached the db to see if someone can help me with this. I don't understand what the problem is that access won't allow.
Well that was easy. Is there a way to add multiple fields without listing each field individually? Because as my formulas go across the page I need to add all the fields together from start to field previously?
12/31/2003 to 2/29/2003 for the 3/31/2003 field
12/31/2003 to 3/31/2003 for the 4/30/2003 field