By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,315 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,315 IT Pros & Developers. It's quick & easy.

Duplicate Query Expression Question

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"JimFor" <ji****@aol.comNOSPAM> wrote in message
news:20***************************@mb-m21.aol.com...
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


Use cut and paste. But do it in SQL view. That's in the View menu.

Robert Crouser
Nov 12 '05 #2

P: n/a
Thanks!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.