Full Version: Simple query calculation
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
lamington
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.
lamington
Thanks anyone who might have looked, but I've figured it out.

Must have been having another one of my blonde moments (Quite common for me....I am blonde after all)!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.