By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,116 Members | 1,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,116 IT Pros & Developers. It's quick & easy.

EMAILING A REPORT AS ATTACHMENT LINKED TO A SPECIFIC RECORD IN A QUERY

P: n/a
I have a report with it's source from a query. The query calls data
from 3 related tables. The report is a meeting agenda and I only want
to attach a snapshot report to my email based on the specific record
on a form. I tried using stLinkCriteria but it always captures all
the records on my query as one snapshot attachment with all the
records. The only way I can filter the record I wanted was to add a
field to my table that users manually set to "Yes" and the query
criteria set to "Yes". After sending the email, my users have to
uncheck the Yes box. I would like to not use this option. Help
please!

Fred Crisostomo

May 20 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
you can base your report on the criteria in your form

<cr************@gmail.comwrote in message
news:11**********************@a26g2000pre.googlegr oups.com...
>I have a report with it's source from a query. The query calls data
from 3 related tables. The report is a meeting agenda and I only want
to attach a snapshot report to my email based on the specific record
on a form. I tried using stLinkCriteria but it always captures all
the records on my query as one snapshot attachment with all the
records. The only way I can filter the record I wanted was to add a
field to my table that users manually set to "Yes" and the query
criteria set to "Yes". After sending the email, my users have to
uncheck the Yes box. I would like to not use this option. Help
please!

Fred Crisostomo

May 20 '07 #2

P: n/a
On May 20, 6:55 pm, "Scott" <a@awrote:
you can base your report on the criteria in your form

<crisostomof...@gmail.comwrote in message

news:11**********************@a26g2000pre.googlegr oups.com...
I have a report with it's source from a query. The query calls data
from 3 related tables. The report is a meeting agenda and I only want
to attach a snapshot report to my email based on the specific record
on a form. I tried using stLinkCriteria but it always captures all
the records on my query as one snapshot attachment with all the
records. The only way I can filter the record I wanted was to add a
field to my table that users manually set to "Yes" and the query
criteria set to "Yes". After sending the email, my users have to
uncheck the Yes box. I would like to not use this option. Help
please!
Fred Crisostomo- Hide quoted text -

- Show quoted text -
Thanks Scott. I solved the problem by applying an expression to my
report query.

May 21 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.