speshulk926
Member
- Joined
- May 23, 2007
- Messages
- 8
- Programming Experience
- 1-3
I am having issues getting a report to show up correctly for what I need it to do. I have 2 Tables: PrintLog and Letters. I need to set up a report that for each Letter in the Letters table to show what it has printed.
There will be multiple LetterCounts for 1 Letter. This is where I am running into a problem. I haven't figured out how to group them so that it will display each letter from the Letters table and list how many letters printed total after adding all of the LetterCounts in the PrintLog table.
If you need more information, let me know. I tried to be as descriptive as possible.
Edit: this may help too...
Here's 3 sample entries inside of the PrintLog Table:
So Achform should show 18 letters printed and Chgbenef should show it printing 13 letters. Hope that helps some! I'm lost!
VB.NET:
Print Log Table:
[b]Print_ID int[/b]
Used as an identity field.
[b]Letter_ID int[/b]
Corresponds to the Letter_ID field in the Letters table.
[b]PrintDate datetime[/b]
The day the letter printed (used for record selection after i get the report working)
[b]LetterCount int[/b]
Displays the total letter count for that day.
There will be multiple LetterCounts for 1 Letter. This is where I am running into a problem. I haven't figured out how to group them so that it will display each letter from the Letters table and list how many letters printed total after adding all of the LetterCounts in the PrintLog table.
If you need more information, let me know. I tried to be as descriptive as possible.
Edit: this may help too...
Here's 3 sample entries inside of the PrintLog Table:
VB.NET:
[u]PrintID[/u] [u]LetterID[/u] [u]PrintDate[/u] [u]LetterDate[/u] [u]Description[/u] [u]LetterCount[/u]
1 4 5/9/2007 12:00:00 AM 4/26/2007 12:00:00 AM Achform 18
2 16 5/9/2007 12:00:00 AM 4/26/2007 12:00:00 AM Chgbenef 4
3 16 5/10/2007 12:00:00 AM 4/26/2007 12:00:00 AM Chgbenef 9
So Achform should show 18 letters printed and Chgbenef should show it printing 13 letters. Hope that helps some! I'm lost!
Last edited: