Spilt table by criteria for distribution

[IBTLP]

I need help splitting a table for distribution. I have a large table with data on it for 52 vendors. I want to sub divide the table by their reference number and send "their section" from the large table to one or more email address'. Is this possible and how would I do it? The process needs to be repeatable because the large table changes every 3 months and is sent again with new data on it. each vendor could revive 1 to 100 rows and its always 8 columns.

Would be nice if I could also summarize the sectioned area with a count and a sum

Thanks in advance for your time and assistance.

[jimatqsi]

What is the format you are sending the data in? You want to send them an Access table, or put the data in a report or a spreadsheet?

Whatever the data format you need to write a query to select the data. How you use that will depend on what it is you are trying to send the data in.

Jim

[IBTLP]

Hello Jim thank for having a look. I was looking at queries yesterday but having not worked in Access for a few years I could not see a way to slice up the main sheet in a way that would allow simple distribution.

As for format: PDF would be preferred but to be honest I would take what I can get to not have to manually send 50 separate emails/attachments. Anything mainstream is fine

Best,
T

[TjabbeTjibsma]

I think before you can get anything useful in terms of output, you need to now how you are going to filter / select your data.

You say you have a reference number for each vendor? In that case you can group by reference number in a report. Or create a report for each reference number (probably have to use VBA for that).

In any case, to really help you, we need some more info on your table structure and the end product you're trying to achieve.

[IBTLP]

Each row has the vendor reference number so this would be the criteria to sub divide the table by. I can run a report to group them but failed to break out the vendors to a new table or do an email distribution.

Thanks for having a look and helping with this!

T

[NeoPa]

Have you considered linking tables to separate Back Ends (BEs)? You would run an APPEND query after clearing the existing data. The APPEND query would be filtered on the Vendor reference Number. When the table has been correctly populated using your Front End you can email the relevant BE to the vendor.