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
|
|||
|
|||
Need Help Urgently - Deadline is Monday
I have a big problem.
I currently have a database when the user enters the date range to run the report it places each day within that date range on a seperate sheet of paper. My problem is: My new employer wants the information for the whole week on one sheet. They want the column headings down the left side. Accross the top they want Monday - Saturday accross the top with the last column being a total column. To use their words they would like for it to look like an excel spreadsheet. Example of what they want is below. Can this be done? The only thing I can think of is to print the reports and actually key the information into a seperate excel spreadsheet. Any and all help is greatly appreciated. I was told about this today and they want the finished product on Monday. They would also like to have a monthly report using the same layout except for using the days of the week they want it to use the date range for the week. Any and all help is greatly appreciated. MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY TOTAL Total Trucks 15 25 20 10 5 75 |
#2
|
|||
|
|||
Need Help Urgently - Deadline is Monday
Lucky,
What you need is a crosstab query. I assume that each row of the report will be for a separate week? or is each row supposed to contain what used to be the column headings for each day? In your query, you will probably have to create a calculated field to indicate which week of the month the date falls, and another to indicate which day (use the format function to format the date as a day "dddd"). Then when you make the query a crosstab, you will need to include the week as a RowHeader and the day of the week as a column header. For more detailed help, you will need to post the SQL of your current query. Dale HTH "lucky33" wrote in message ... I have a big problem. I currently have a database when the user enters the date range to run the report it places each day within that date range on a seperate sheet of paper. My problem is: My new employer wants the information for the whole week on one sheet. They want the column headings down the left side. Accross the top they want Monday - Saturday accross the top with the last column being a total column. To use their words they would like for it to look like an excel spreadsheet. Example of what they want is below. Can this be done? The only thing I can think of is to print the reports and actually key the information into a seperate excel spreadsheet. Any and all help is greatly appreciated. I was told about this today and they want the finished product on Monday. They would also like to have a monthly report using the same layout except for using the days of the week they want it to use the date range for the week. Any and all help is greatly appreciated. MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY TOTAL Total Trucks 15 25 20 10 5 75 |
#3
|
|||
|
|||
Need Help Urgently - Deadline is Monday
Hi,
Please provide your table and field names, including primary fields. For the first report does the user only report on a single week's worth of data? Or on multiple weeks' worth? Any other details we should know about your data? Clifford Bass lucky33 wrote: I have a big problem. I currently have a database when the user enters the date range to run the report it places each day within that date range on a seperate sheet of paper. My problem is: My new employer wants the information for the whole week on one sheet. They want the column headings down the left side. Accross the top they want Monday - Saturday accross the top with the last column being a total column. To use their words they would like for it to look like an excel spreadsheet. Example of what they want is below. Can this be done? The only thing I can think of is to print the reports and actually key the information into a seperate excel spreadsheet. Any and all help is greatly appreciated. I was told about this today and they want the finished product on Monday. They would also like to have a monthly report using the same layout except for using the days of the week they want it to use the date range for the week. Any and all help is greatly appreciated. MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY TOTAL Total Trucks 15 25 20 10 5 75 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
Thread Tools | |
Display Modes | |
|
|