J
jimpaige
I want to email each of my sales reps a snapshot of a Access report that
lists their sales invoices for the month (only their sales invoices)
Presently I do this by running a macro that runs a query, report & emails a
snapshot.
I physically enter the value for a field [REP] as a variable for the query.
It works fine, but we now have 20 reps so I have to run this macro and type
in each of teh 20 rep codes, and I trasnpose.
I need to create to automate this so that Access can change the query based
on thte [REP] field in a table.
I have table #1 that has one record for each rep with fields: [REP] and
[REPName] and [RepEMAIL]
Have Table #2- that has 1 record for each sales invoice-- and has the field
[REP]
How can I use the field [REP] in Tabel1 and select off records in Table2 for
each value of [REP] in Table1-- to create a separate report, snapshot and
email for each [REP]
Thanks,
Jim
lists their sales invoices for the month (only their sales invoices)
Presently I do this by running a macro that runs a query, report & emails a
snapshot.
I physically enter the value for a field [REP] as a variable for the query.
It works fine, but we now have 20 reps so I have to run this macro and type
in each of teh 20 rep codes, and I trasnpose.
I need to create to automate this so that Access can change the query based
on thte [REP] field in a table.
I have table #1 that has one record for each rep with fields: [REP] and
[REPName] and [RepEMAIL]
Have Table #2- that has 1 record for each sales invoice-- and has the field
[REP]
How can I use the field [REP] in Tabel1 and select off records in Table2 for
each value of [REP] in Table1-- to create a separate report, snapshot and
email for each [REP]
Thanks,
Jim