Columns in a MS access report

Adonald

New Member
Joined
Dec 31, 2003
Messages
5
I am trying to create a report in Access that has two running columns of information and am running into some difficulty. I have gone into page settings and changed the column property to what I need it be and when viewed for the first time it works fine but even after saving the next time the report is viewed it reverts back to having only one column. Any help is greatly appreciated.

Thanks
Adam
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
If you're using Access 2000, there is a bug that causes report formatting to revert to the default settings. You can either install Service Pack 1, or just go to TOOLS/OPTIONS/GENERAL and un-check all the Name Autocorrect features. That will fix it too.
 
Upvote 0
Thanks for replying I will try these Ideas out. Good to finally see another maple leaf flag out there too by the way!

Adam
 
Upvote 0
OK so I tried the one suggestion of unchecking the autocorrect features but now I get the same values in the both columns like a copy for example I get

1A1B 1A1B
2A2B 2A2B

when I need
1A1B 2A2B
3A3B 4A4B

Have any suggestions?
Adam
 
Upvote 0

Forum statistics

Threads
1,221,614
Messages
6,160,839
Members
451,673
Latest member
wella86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top