Change the layout of the data in my query

[Carla C]

Hello just a simple question, can anyone tell me how I change the layout in a query??

I would like my quatities centred and my figures set to right justification and Access wont let me!!

Thanks in advance.

[pbaldy]

Most of us don't let users into tables or queries anyway. Present the query data in a form or report and do your formatting there.

[Carla C]

The boss wants to use the query form

[pbaldy]

Then tell the boss they will have virtually no control over formatting or what the user does while using the query.

[Carla C]

I did already.. Thanks

[pbaldy]

No problem. I'm so glad to work for people that don't try to dictate how I design things. They just want the applications to accomplish the necessary goals.

[Carla C]

Am I best to create a report for him do you think? Can I change the headings on a report to suit?

[pbaldy]

That is what I would do. You have a lot more control there. You can make the headings anything you want.

[Carla C]

Ok, cool, I set one up yesterday but I have just one more question, how do I create filters on a report?

[pbaldy]

The two common methods are basing the report on a parameter query and this technique:

BaldyWeb wherecondition