Quary help

[pawandmaw]

additional information is, I am using access 2007
And I am trying to do a caculation on week discount rate
Weekly discount rate=weekly rate*.15
but how do you put this in a new column and how please?
Thanks
David

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 03:54:02 -0700, pawandmaw

In query design view go to an empty column and write:
WDR: [weekly rate]*.15
I am assuming [weekly rate] is a column in the underlying table.

-Tom.
Microsoft Access MVP