|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 4th, 2006, 08:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Queries
5 d) Create a query to show the name of the company whose price changed most
during the month of July and whose headquarters are in New York. (Hint: Use the difference between the opening price in the first week of July and the closing price in the last week of July, if July is not included in your data, please use another month.) Could you please help me to do this query in SQL view? Thank you !!! 
|
|
#2
October 4th, 2006, 09:08 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Queries
Is this a class project or a final exam question?
What about if the price peaked in the middle of the month and then fell again? "Altysha" wrote: 5 d) Create a query to show the name of the company whose price changed most during the month of July and whose headquarters are in New York. (Hint: Use the difference between the opening price in the first week of July and the closing price in the last week of July, if July is not included in your data, please use another month.) Could you please help me to do this query in SQL view? Thank you !!!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
