Hello Everyone,
I have a budget forecasting project, I'm trying to collect some ideas and wanted your opinion.

How can I best display a form that contains say Volume Month by Month in a format similar to this:
Jan Feb Mar April May
123 234 567 897 212

Since the volume will be coming in from a database in a simple format like:
Month Volume
Jan 123
Feb 234
Mar 567

How can I display it best on a form in a horizontal format vs. a Vertical format?

Thanks

Have you played with a crosstab query?

Or create a chart on a form

A crosstab query sounds exactly what I nee Paul, I haven't had a need to create many but I'll brush up on that type of query.

Thanks