94Sport5sp
Registered User.
- Local time
- Yesterday, 20:59
- Joined
- May 23, 2012
- Messages
- 115
[FONT=Arial, sans-serif]Hi:[/FONT]
[FONT=Arial, sans-serif]For the system I created last fall, the user has asked me to display a report to summarize data by date within sales area. There is no intention of printing the results so I could use either a form or a report and I elected to use a form.[/FONT]
[FONT=Arial, sans-serif]Overview of the data:[/FONT]
[FONT=Arial, sans-serif]The system I created collects sales data on a daily basis with the data grouped by sales area. Information received includes sales area (areas will be grouped later), date of sale, total quantity sold and total selling price. Management will then adjust the data based on reported errors/omissions. When complete, management will then balance the days sales and then data is saved for future processing.[/FONT]
[FONT=Arial, sans-serif]So now I have enough data to provide meaningful information. Client wants a summary of information in the following format:[/FONT]
[FONT=Arial, sans-serif]Column heading for sales summary:[/FONT]
[FONT=Arial, sans-serif]Date, Item1, Item2, Item3, Item4 etc[/FONT]
[FONT=Arial, sans-serif]Information to display:[/FONT]
[FONT=Arial, sans-serif]Mar 1, 21.10, 15.75, 31.31, 58.75, etc[/FONT]
[FONT=Arial, sans-serif]Mar 2, 15.34, 28.23, 88.75, 103.95, etc[/FONT]
[FONT=Arial, sans-serif]and so on for the time period selected.[/FONT]
[FONT=Arial, sans-serif]End with totals by column.[/FONT]
[FONT=Arial, sans-serif]The above will provide sales information by area which is then exported to Excel for transfer to the accountant.[/FONT]
[FONT=Arial, sans-serif]I created a form using the cross tab feature to display the above information with a button to export to Excel and all was looking good until I came across a problem.[/FONT]
[FONT=Arial, sans-serif]Some areas may have no sales (ie closed or not in use that day) and my displayed information will have gaps in the days. So areas 1, 5, 7 may have sales every day but areas 2, 6, 8 may only have sales M-F and area 3 may only have sales on the weekend. So now I need to figure out how to create a display for all the days of the selected time period with 0 amounts on days without any sales.[/FONT]
[FONT=Arial, sans-serif]So, looking for ideas, suggestion, thoughts....[/FONT]
[FONT=Arial, sans-serif]Thanks[/FONT]
[FONT=Arial, sans-serif]For the system I created last fall, the user has asked me to display a report to summarize data by date within sales area. There is no intention of printing the results so I could use either a form or a report and I elected to use a form.[/FONT]
[FONT=Arial, sans-serif]Overview of the data:[/FONT]
[FONT=Arial, sans-serif]The system I created collects sales data on a daily basis with the data grouped by sales area. Information received includes sales area (areas will be grouped later), date of sale, total quantity sold and total selling price. Management will then adjust the data based on reported errors/omissions. When complete, management will then balance the days sales and then data is saved for future processing.[/FONT]
[FONT=Arial, sans-serif]So now I have enough data to provide meaningful information. Client wants a summary of information in the following format:[/FONT]
[FONT=Arial, sans-serif]Column heading for sales summary:[/FONT]
[FONT=Arial, sans-serif]Date, Item1, Item2, Item3, Item4 etc[/FONT]
[FONT=Arial, sans-serif]Information to display:[/FONT]
[FONT=Arial, sans-serif]Mar 1, 21.10, 15.75, 31.31, 58.75, etc[/FONT]
[FONT=Arial, sans-serif]Mar 2, 15.34, 28.23, 88.75, 103.95, etc[/FONT]
[FONT=Arial, sans-serif]and so on for the time period selected.[/FONT]
[FONT=Arial, sans-serif]End with totals by column.[/FONT]
[FONT=Arial, sans-serif]The above will provide sales information by area which is then exported to Excel for transfer to the accountant.[/FONT]
[FONT=Arial, sans-serif]I created a form using the cross tab feature to display the above information with a button to export to Excel and all was looking good until I came across a problem.[/FONT]
[FONT=Arial, sans-serif]Some areas may have no sales (ie closed or not in use that day) and my displayed information will have gaps in the days. So areas 1, 5, 7 may have sales every day but areas 2, 6, 8 may only have sales M-F and area 3 may only have sales on the weekend. So now I need to figure out how to create a display for all the days of the selected time period with 0 amounts on days without any sales.[/FONT]
[FONT=Arial, sans-serif]So, looking for ideas, suggestion, thoughts....[/FONT]
[FONT=Arial, sans-serif]Thanks[/FONT]
