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
|
|||
|
|||
"Hold" values?
If possible I need to create a query with data from all 4 or 5 weeks in a
period, layed out in columns like a spreadsheet. Example: W/E 2/5/05 W/E 2/12/05 W/E 2/19/05 W/E 2/26/05 Number Dollar Number Dollar Number Dollar Number Dollar 1 $15 1 $5.97 4 $15.99 1 $40.00 The user runs this report by week, so what can I do to "capture" the week ending dates, along with the number and dollar amounts so I can add each week as I go along? The week ending dates are in a table joined to the table containing the number and dollar fields. Thanks for any help I can get on this! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to calculate values from 2 tables | Luke | Running & Setting Up Queries | 2 | December 9th, 2004 03:55 PM |
average, eliminating zero values | Chris | Worksheet Functions | 6 | May 14th, 2004 11:36 PM |
Look up values in one column based on values in another without repeating | Frank Kabel | Worksheet Functions | 4 | April 8th, 2004 10:54 PM |
Look up values in one column based on values in another without repeating | fbarbie | Worksheet Functions | 0 | April 8th, 2004 09:38 PM |
Formula cell references when sorting values in another worksheet | Frank Kabel | Worksheet Functions | 0 | March 30th, 2004 11:27 AM |