ysquared86
New member
- Local time
- Today, 14:05
- Joined
- Nov 7, 2008
- Messages
- 9
I am a total access novice, but I have been designing an order database for my company, and am trying to implement an automatic invoice-generating report based on my query from the tables.
The problem is that each item is entered as separate entries, and sometimes a bunch of them are supposed to go on the same invoice page. Of course, there is an [Invoice Number] field cuz I foresaw that I'm gonna have to group them eventually. But I'm at a loss as to how to do so.
Basically what I want is something that takes every entry with the same invoice number, pulls out the item number, price, quantity etc from each entry, then stacks them neatly into a table. So kind of like concatenating strings, but with tabular data...
Is this possible? I'd have to imagine it is. Please help.
The problem is that each item is entered as separate entries, and sometimes a bunch of them are supposed to go on the same invoice page. Of course, there is an [Invoice Number] field cuz I foresaw that I'm gonna have to group them eventually. But I'm at a loss as to how to do so.
Basically what I want is something that takes every entry with the same invoice number, pulls out the item number, price, quantity etc from each entry, then stacks them neatly into a table. So kind of like concatenating strings, but with tabular data...
Is this possible? I'd have to imagine it is. Please help.