Duplicate Query Expression Question

Hi,

Is there any way in Access 2002 to copy a query expression from a query which
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 query
which calculates the total price of an order by multiplying the unit price of
an item times the number of items bought and also subtracting any discount. You
call that query "Order Subtotals." The Order Subtotals query consists of a
column showing an order number and a column showing the order dollar amount.
How can you write another query using the equation which calculated the order
dollar amount without retyping the entire equation used to calculate the order
dollar amount? Tried cut and paste and using the "Build" function and have
not had any luck.

Thanks

"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

Thanks!