| re: Duplicate Query Expression Question
"JimFor" <jimfor@aol.comNOSPAM> wrote in message
news:20040307155350.29604.00001027@mb-m21.aol.com...[color=blue]
> Hi,
>
> Is there any way in Access 2002 to copy a query expression from a query[/color]
which[color=blue]
> was already set up to one which is being made? This would avoid having to
> enter a long equation more than once. For example, suppose you have a[/color]
query[color=blue]
> which calculates the total price of an order by multiplying the unit[/color]
price of[color=blue]
> an item times the number of items bought and also subtracting any[/color]
discount. You[color=blue]
> call that query "Order Subtotals." The Order Subtotals query consists of[/color]
a[color=blue]
> column showing an order number and a column showing the order dollar[/color]
amount.[color=blue]
> How can you write another query using the equation which calculated the[/color]
order[color=blue]
> dollar amount without retyping the entire equation used to calculate the[/color]
order[color=blue]
> dollar amount? Tried cut and paste and using the "Build" function and[/color]
have[color=blue]
> not had any luck.
>
> Thanks[/color]
Use cut and paste. But do it in SQL view. That's in the View menu.
Robert Crouser
| 
