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