multiple column forms

[JimL]

Good day to you all!

I have a query that generates 50 records summarizing the count of observations per center. I want to display all the results on one form page, splitting the results into 2 columns.

Is there a way to do so? I can set the query to display the top 25 records, but don't know how to display the bottom 25.

As always, replies are most gratefully appreciated.

Regards

JimL

 

[sxschech]

Would these help?
https://theaccessbuddy.wordpress.co...ect-top-n-or-bottom-n-records-from-a-dataset/
https://www.brainbell.com/tutorials/ms-office/Access_2003/Display_Top_Or_Bottom_Values.htm

 

[theDBguy]

Hi JimL. Would you need to edit the data on the form or is it just for display purposes only?

 

[JimL]

No, just to display.

Thanks

Jim

 

[theDBguy]

No, just to display.

Thanks

Jim

If that's the case, I would suggest using a multi-column report instead of a form. I am not sure if you can embed a multi-column report in a form, but you might give it a try, if you need to add some functionalities, which are only available when using a form. Good luck!

 

[JimL]

Not to seem obtuse, but how do I create a multi-column report?

 

[isladogs]

The other method that will definitely work is to split the list into two.
1. SELECT TOP 25 …. Call that qryTop25
2. Create an unmatched query using the wizard joining the original table and qryTop25. Any unmatched records are the bottom 25.

Now use a form and subform side by side to show the records in the two queries.

Hope that helps

 

[JimL]

Thank you.

This solution works wonderfully.

The singular issue I have is that on both subforms, the first record has what appear to be navigation icons (up and down arrows). Is there a property that I can change to get rid of it? Since the arrows don't do anything, they are nothing more than a distraction for the user.

Again, I appreciate the time and the response you provided.

JimL

 

[isladogs]

Which solution did you use?

If you mean the tiny arrows in the field headings in datasheet view, these are used to sort the data by the selected field either ascending or descending order.
If you don't want that feature, go to the property sheet for the form in design view and set the Shortcut Menu property to No.
If not, please show a screenshot of the issue you are referring to

 

[JimL]

Thank you once again. It worked as advertised.

Have a great week!

JimL

 

[isladogs]

Excellent. Both DBG and I were glad to help.