Hello

I want to make a report in which I can compare the information of 2 different columns (both columns belong to the same field).

Example

01/12 02/12 "COMPARISON COLUMN"
(Datefield1) (Datefield1)

10 12 12/10
11 14 14/11
12 16 16/12
. . ./.
. . ./.
n n n/n

I have 2 issues

1.- I am using the report assistant cause I am not a developer so essentially I need to fix this with R.A.
2.- 01/12 and 02/12 come from a single date field converted to an MY format.

Is there a way to do this???


Regards

Columns didn´t display properly.

01/12 02/12 Target Column

1 2 2/1
2 3 3/2
3 4 4/3
4 5 5/4

Hi David,

I'm not sure I understand your issue. Let me see if I got this straight:

1.) You have 2 tables that contain the field DATEFIELD1.
2.) You want to display DATEFIELD1 from one table and DATEFIELD1 from the other table on the same line in the report.

Is that right?

If so, then JOIN both tables together and create the report against the joined resulting set.