Showing parameter fields side by side

[sebgrb]

Hi,



I have a field in a table called Year. I am doing a query which has two parameters, "Enter first year" and "Enter second year" so that the user can compare values between two years, but I want the two years to display side by side in the query results. They both come from the same field in the table. The query works fine but I want to see the results as follows:

Company, Year 1, Year 2, Payment

At the moment it shows

Company, Year, Payment
With both year 1 and year 2 in one column.

Is there a way to display it as I would like?

Any help greatly appreciated.

Kind regards

[June7]

Don't understand the results you describe. Do you mean:

Company	Year1	Year2
ABC	100	200
DEF	90	100

If so, could try a CROSSTAB query.

[sebgrb]

Thank you, I did try that, but perhaps I didn't do it correctly, I will try again.