Hi everyone,
I'm stuck on what I'm sure is an amazingly simple calculation.
I have a very simple database. I need to create a query to calculate a price increase on rentals of 3%. In my table I have fields [Price] and [PriceIncrease].
The expression I have used in the criteria section of the [PriceIncrease] field is:
[Price]*1.03
When I run the query it returns a blank record. I am not sure why this is not working... it seems so simple.
If someone could help that would be great.
Thanks in advance.