I want to create a Tabbed form in a MS Access database called “Payroll per month”. When this form opens it will have data for only the user opening it by prompting the user to type in their number. The form should contain 12 tabs named from September 2010 – August 2011. The data fields in the tabs are “Account #” and “Expense_Amt”. The tabs should filter the data by Date (Month) from the following query.
SELECT [Payroll Per Month].NAME, [Payroll Per Month].PERSON_NBR, [Payroll Per Month].EXP_ACCOUNT, [Payroll Per Month].EXPENSE_AMOUNT, [Payroll Per Month].PERIOD
FROM [Payroll Per Month]
WHERE ((([Payroll Per Month].PERSON_NBR)=[Enter Person Number]));
Each tab will have a total of the Expense Amt for all the accounts for that month. Attached is a copy of the Table – Payroll Per Month converted to Excel.
Can you help me in achieving this goal as far as creating the tabs on the form to filter the data by month date and totaling them. Thanks