Calculated Query

[rgnsuphc]

I need to write a calculated query that increases the price of first class tickets by 20% and regular class tickets by 10%.



In addition:
* Show the cruise line, departure date, to, from, ship and length of stay fields

First, how would you write an equation for this?
Second, where do I write it, (would it be in the criteria row?)
Third, how do I show all the fields that are typed above?




I have not used access for quite awhile, if anyone can help me out, help will be greatly appreciated.

 

[Trevor G]

You need to use a query. You would have to then select the table(s) with the data n them, then select your fields, then save the query with a name like qryNewPrice and then look to add an expression where you would select teh field and multiple *.2 (which is 20%) and the next field *.1 (which is 10%). That will give you a query with the results but what do you want to do next?

 

[Marbles]

You might have to multiply by 1.2 and 1.1 to show the new prices.
In Design View of the query, use the Builder to do the calculations.

 

[rgnsuphc]

Every time I run the query, every field is blank. I am not really understanding what I am doing wrong.

The equation I am using is First Class Tickets * .20 + First Class Tickets &
Regular Class Tickets * .10 + Regular Class Tickets.

Maybe I need more specific steps, I am just not sure what the problem is.

 

[alansidman]

Post your SQL statement for your query so that we can see exactly what you are doing.

 

[Trevor G]

Every time I run the query, every field is blank. I am not really understanding what I am doing wrong.

The equation I am using is First Class Tickets * .20 + First Class Tickets &
Regular Class Tickets * .10 + Regular Class Tickets.

Maybe I need more specific steps, I am just not sure what the problem is.

Steps are:

Create new query
Select Table
Double click each field you want to dispaly
Change the view to see the data before next step
Save the Query with a name
Select the next empty column in query window
Select the Expression builder
Double click the field you want to calculate on, then add in *.2, click OK
Change the view to see the data with the calculation
Change the view and repeat this step (Next column)for the other calculation Field *.1
Change the view to see the results

Then tidy up and hopefully results can be seen.

If you still don't get it then post your SQL code as suggested by Alan.