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

Printing current record of query result to a report

P: n/a
Hi,

I've created a query that has all calculations needed, and made a report
based on this.

I have then made a form based on this query.

What I would like to do is print only the current record on the form. This
is because the
report is a "letter" and I only want 1 record per page.

Anyone know how to do this? I couldnt see how to do it based on a field, as
the form
was based on a query result, not a table.

Any help is appreciated.
Many thanks,
Craig Mason
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Nevermind, I found a workaround :)
"Craig M" <No**@mPlz.Thx> wrote in message
news:40***********************@news-text.dial.pipex.com...
Hi,

I've created a query that has all calculations needed, and made a report
based on this.

I have then made a form based on this query.

What I would like to do is print only the current record on the form. This
is because the
report is a "letter" and I only want 1 record per page.

Anyone know how to do this? I couldnt see how to do it based on a field, as the form
was based on a query result, not a table.

Any help is appreciated.
Many thanks,
Craig Mason

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.