Column Property In Reports

[Keypad]

Hello,

Is is possible to use the Column property in reports. I have some fields in
my main table that are linked to other tables. In my report the fields that
are linked to other tables show the column 1 record numbers. Is there a way
to format those fields to show column 1 instead.

 

[Keypad]

my main table that are linked to other tables. In my report the fields that

are linked to other tables show the column 1 record numbers.

Meant to say column 0 record numbers

 

[KARL DEWEY]

I suspect that it is not showing record numbers but an autonumber field
numbers.

Post the SQL of the query that feeds your report. Open in design view,
click on VIEW - SQL View, highlight all, copy, and paste in a post.

 

[Keypad]

Karl,

I found out what was wrong. I needed to add FK's to my Main table from all
other tables that were linked to Main. Then in the Join Properties I had to
select the third option which is "Include all records from Main, and only
those records from "NAME OF LINKED TABLE" where the joined fields are equal".

After that, I had to drag all FK's from Main into the query window. Then
drag all fields from linked tables into the query window. Everything worked
after that.

I had originally dragged primary keys from all tables into query window,
that's where things went wrong. Thank you for responding to my post. Hope
this helps other people in cyberspace struggling to make things work.

KP