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! |
#2
|
|||
|
|||
You're not going to be able to get a query to return results that look like
that, but you could get a report to do so. Create a query that returns results that look like: WeekEnding Number Dollar 2/5/05 1 15.00 2/5/05 2 xx.yy 2/12/05 1 5.97 2/19/05 1 40.00 Now create a report based on this query. Group it by WeekEnding, and put the [WeekEnding] field in the Group Header. Then put the Number and Dollar titles in the the Group Header as well. Finally, put the [Number] and [Dollar] text columns in the detail section. Then, select File-Page Setup, then select the columns tab and indicate the number of columns you want, the spacing between the columns, the width of the columns, etc. You may find that you want a header on the Report, in which case, I would recommend making the report we created above a subreport that you mount inside a report that has the Title, Page number, Date printed, etc. HTH Dale "cottage6" wrote in message news 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! |
#3
|
|||
|
|||
Dale, thanks for getting back to me. I'm somewhat confused. Since the week
ending dates are in 1 field, when I prompt the user for W/E 02/05/05 to get that data, the next time she runs the query for the next W/E date all the numbers will change to reflect that date. Don't I need a way to store the W/E 02/05 values? "Dale Fye" wrote: You're not going to be able to get a query to return results that look like that, but you could get a report to do so. Create a query that returns results that look like: WeekEnding Number Dollar 2/5/05 1 15.00 2/5/05 2 xx.yy 2/12/05 1 5.97 2/19/05 1 40.00 Now create a report based on this query. Group it by WeekEnding, and put the [WeekEnding] field in the Group Header. Then put the Number and Dollar titles in the the Group Header as well. Finally, put the [Number] and [Dollar] text columns in the detail section. Then, select File-Page Setup, then select the columns tab and indicate the number of columns you want, the spacing between the columns, the width of the columns, etc. You may find that you want a header on the Report, in which case, I would recommend making the report we created above a subreport that you mount inside a report that has the Title, Page number, Date printed, etc. HTH Dale "cottage6" wrote in message news 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! |
#4
|
|||
|
|||
Dale, never mind. I was making this a lot harder than it needed to be.
That's what inexperience will get you! "cottage6" wrote: Dale, thanks for getting back to me. I'm somewhat confused. Since the week ending dates are in 1 field, when I prompt the user for W/E 02/05/05 to get that data, the next time she runs the query for the next W/E date all the numbers will change to reflect that date. Don't I need a way to store the W/E 02/05 values? "Dale Fye" wrote: You're not going to be able to get a query to return results that look like that, but you could get a report to do so. Create a query that returns results that look like: WeekEnding Number Dollar 2/5/05 1 15.00 2/5/05 2 xx.yy 2/12/05 1 5.97 2/19/05 1 40.00 Now create a report based on this query. Group it by WeekEnding, and put the [WeekEnding] field in the Group Header. Then put the Number and Dollar titles in the the Group Header as well. Finally, put the [Number] and [Dollar] text columns in the detail section. Then, select File-Page Setup, then select the columns tab and indicate the number of columns you want, the spacing between the columns, the width of the columns, etc. You may find that you want a header on the Report, in which case, I would recommend making the report we created above a subreport that you mount inside a report that has the Title, Page number, Date printed, etc. HTH Dale "cottage6" wrote in message news 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 |