select record value in a report

R

Rickm

I have a Table with 3 records (pulled in from an excel spreadsheet with
labels).
Label A Label B Label C Label D Label E
1111 1222 1333 1444 1555
2111 2222 2333 2444 2555
3111 3222 3333 3444 3555

I wish to display the data in a report as follows:
Label B Label E
"record 1" 1222 1555
"record 2" 2222 2555
"record 3" 3222 3555

Can I use a text box properties sheet Control Source
to pull the data from the table without having to do a query
or other manipulation?
If necessary, I can load 3 separate tables with 1 record each.
Your input is appreciated!
 
G

golfinray

It would be far easier to do that on a form and then open your report from
the form after selecting what you want.
 
G

golfinray

It would be far easier to do that on a form and then open your report from
the form after selecting what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing a value from a form in a report header 4
How to add a Serial no Field in Label Report? 2
Access 2003 Report - want only one field with a value to show 12
Forcing printing of a record multiple times 6
Using Table Value in a Form 5
Transpose data in a report-Field values broken down to separate co 9
Printing only fields that have a value on report 1
Restart record count when the value in a specific field changes 3

Top