UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Simple query calculation    
 
   
lamington
post Nov 14 2004, 04:03 AM
Post #1

New Member
Posts: 18
From: Qld, Australia



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.
Go to the top of the page
 
+
lamington
post Nov 14 2004, 04:26 AM
Post #2

New Member
Posts: 18
From: Qld, Australia



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)!
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 04:58 AM