select record value in a report

  • Thread starter Thread starter Rickm
  • Start date Start date
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!
 
It would be far easier to do that on a form and then open your report from
the form after selecting what you want.
 
It would be far easier to do that on a form and then open your report from
the form after selecting what you want.
 
Back
Top