|
| 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
February 16th, 2006, 09:31 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Create a report for hours by week, month and year.
I need to create a report for flight hours. I need the report to show detail
records for the week with totals in the footer. I have already created this where you input the date parameters. It work fine. Here is where the problem is. I also need another line with totals for the month and another with totals for the year. The report I have so far keeps track of flight times, maintenence flight times, pax and so on. They each need to have their own total. Unfortunately I don't know much about access. I was thrown into this and have menaged to get as far as I have using the report wizards, online searching and trial and error. Thanks. 
|
|
#2
February 16th, 2006, 10:38 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Create a report for hours by week, month and year.
Edd,
In the query behind your report (using the design grid) create two calculated fields... txtMonth : Month([YourDateFieldName]) and txtYear : Year([YourDateFieldName]) This will provide a Year and Month value for each date so that you can "break and sum" the report on those values. Ex... Year Header Month Header Detail Month Header YearHeader -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Edd" wrote in message ... I need to create a report for flight hours. I need the report to show detail records for the week with totals in the footer. I have already created this where you input the date parameters. It work fine. Here is where the problem is. I also need another line with totals for the month and another with totals for the year. The report I have so far keeps track of flight times, maintenence flight times, pax and so on. They each need to have their own total. Unfortunately I don't know much about access. I was thrown into this and have menaged to get as far as I have using the report wizards, online searching and trial and error. Thanks.
|
|
#3
February 17th, 2006, 12:52 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Create a report for hours by week, month and year.
Thank you for your help but I'm not sure what to do with it after creating
the fields for txtMonth and txtYear. You did mean create two new colums for these fields right? After that what does it mean to "break and sum" on the report? Thanks. "Al Camp" wrote: Edd, In the query behind your report (using the design grid) create two calculated fields... txtMonth : Month([YourDateFieldName]) and txtYear : Year([YourDateFieldName]) This will provide a Year and Month value for each date so that you can "break and sum" the report on those values. Ex... Year Header Month Header Detail Month Header YearHeader -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Edd" wrote in message ... I need to create a report for flight hours. I need the report to show detail records for the week with totals in the footer. I have already created this where you input the date parameters. It work fine. Here is where the problem is. I also need another line with totals for the month and another with totals for the year. The report I have so far keeps track of flight times, maintenence flight times, pax and so on. They each need to have their own total. Unfortunately I don't know much about access. I was thrown into this and have menaged to get as far as I have using the report wizards, online searching and trial and error. Thanks.
|
|
#4
February 17th, 2006, 01:39 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Create a report for hours by week, month and year.
Edd,
I see you also wanted a total by week, so I want to back up a bit. You'll need 3 calculated fields... Tell you what might be easier. EMail me through my website below, and I'll send you a .mdb file with a report that shows what you'll need to do. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Edd" wrote in message ... Thank you for your help but I'm not sure what to do with it after creating the fields for txtMonth and txtYear. You did mean create two new colums for these fields right? After that what does it mean to "break and sum" on the report? Thanks. "Al Camp" wrote: Edd, In the query behind your report (using the design grid) create two calculated fields... txtMonth : Month([YourDateFieldName]) and txtYear : Year([YourDateFieldName]) This will provide a Year and Month value for each date so that you can "break and sum" the report on those values. Ex... Year Header Month Header Detail Month Header YearHeader -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Edd" wrote in message ... I need to create a report for flight hours. I need the report to show detail records for the week with totals in the footer. I have already created this where you input the date parameters. It work fine. Here is where the problem is. I also need another line with totals for the month and another with totals for the year. The report I have so far keeps track of flight times, maintenence flight times, pax and so on. They each need to have their own total. Unfortunately I don't know much about access. I was thrown into this and have menaged to get as far as I have using the report wizards, online searching and trial and error. Thanks.
|
|
#5
February 17th, 2006, 01:43 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Create a report for hours by week, month and year.
Edd,
What version of Access are you running? -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Al Camp" wrote in message ... Edd, In the query behind your report (using the design grid) create two calculated fields... txtMonth : Month([YourDateFieldName]) and txtYear : Year([YourDateFieldName]) This will provide a Year and Month value for each date so that you can "break and sum" the report on those values. Ex... Year Header Month Header Detail Month Header YearHeader -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Edd" wrote in message ... I need to create a report for flight hours. I need the report to show detail records for the week with totals in the footer. I have already created this where you input the date parameters. It work fine. Here is where the problem is. I also need another line with totals for the month and another with totals for the year. The report I have so far keeps track of flight times, maintenence flight times, pax and so on. They each need to have their own total. Unfortunately I don't know much about access. I was thrown into this and have menaged to get as far as I have using the report wizards, online searching and trial and error. Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Report by Month and Year | FJB | Setting Up & Running Reports | 3 | November 11th, 2005 03:48 AM |
| Query week to date, month to date, year to date hours | Ty | Running & Setting Up Queries | 1 | December 15th, 2004 03:46 AM |
| Report totals - breakdown by month, quarter, & year | Paul Kraemer | Setting Up & Running Reports | 1 | December 13th, 2004 06:45 PM |
| date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |
Linear Mode
