Displaying multiple months worth of data on the same form

[halabis]

I have a form that has a field for (amongst many other fields) EmployeeName, Month, and Quality. I sort typically filter the data by Month in order to find the quality for each employee for that month.

What I need to do now is to display/work with the Quality for each employee for the past 6 months. What formula can I put in the text box to have it show me the quality for the previous month, and then another for the month before that, etc so that I have 6 text boxes one for each of the last 6 month's quality.


Thanks,

[NTC]

a form has a record source that can be either a table or query; develop a query that has criteria to result in the 6 months - then copy your form and source it on this query...

[halabis]

The data is in the query. I just don't know how to pull it to the form. I can view each month individualy, I don't know how to view them all at once.

[NTC]

If you want a form that looks much like a query; while the query is open - go to the ribbon, Create, and select Form - try using the Wizard and go for a tabular design....

[halabis]

Sorry, I don't think I am being clear. I currently have a large and complex (to me) form that I created that tracks several things. One of the many things it tracks is employee quality. But it only does so for the current month. The query I use to pull the data however pulls every month's quality. In order to display the current month's statistics I apply a filter to the month field for the current month. This removes all the pages that have previous month's data. What I want to be able to do is retain this functionality while also being able to display the previous month's quality statistic for the person whose page I have pulled up. The field that has the quality in it is labled as "Quality" I don't know what formula to put into a second field in order for it to also diplay something from the "Quality" field of my query, but from a month that is different from the one I filtered for.

Example. I want to see John Doe's August numbers across all areas. I need to be able to filter all the data for what John Doe did in August. Except I also want to see what John's Quality was in June and July as well. It needs to be done with one query that I run for all my employees.

Sorry for the confusion.

[NTC]

it does not sound like your current form will be able to display multiple months of data as you seek....so refer to my prior post in making a form that you need...

[halabis]

Ok, I figured it out.

I created a new cross tab query with the Employee name as the rows, dates as the columns, and quality as the Value. Then I created a new query that pulled the original query and the cross tab query. Finally I pointed my form to the combined query instead of the original one and was able to pull all the quality data appropriately associated with the Employee names on a given date, even after filtering.