Combo box problem to Report

[mpjr]

I have a table with 160 records. I am trying to set up my form so the user
can select a record from a combo box, enter the payroll in a text box field
and submit. Then they can perform the same function several times and each
record will show up on my report with the payroll for each separate record.
I’ve tried the combo box on the form page but when you select one or several
selections, all 160 records are displayed on the reports page.

Would also like a suggestion on how to have it set up for the user to enter
the payroll (automatically rounded to the closest dollar) each time they
select a record. Would also like to show the sum (on the reports page) of all

payroll amounts selected on the forms page. Any comments will be appreciated.

--

 

[OldPro]

I have a table with 160 records. I am trying to set up my form so the user
can select a record from a combo box, enter the payroll in a text box field
and submit. Then they can perform the same function several times and each
record will show up on my report with the payroll for each separate record.
I've tried the combo box on the form page but when you select one or several
selections, all 160 records are displayed on the reports page.

Would also like a suggestion on how to have it set up for the user to enter
the payroll (automatically rounded to the closest dollar) each time they
select a record. Would also like to show the sum (on the reports page) of all

payroll amounts selected on the forms page. Any comments will be appreciated.

--

Try to think in terms of tables, records, and fields. Your
description is vague and somewhat ambiguous. If for example, you have
a employee table and want to create payroll records for a payroll
table, then you would use a control that allows the user to select the
employee, and another that allows input of their remuneration. Then
you could add a command button that saves the record to the payroll
table with todays' date. A separate command button could fill a
report table with only those records which have been selected, and
then call a report that gets its data from that table.

 

[mpjr via AccessMonster.com]

I have a table from which the person selects the classification of the type
of work performed during that reporting monthly period. Once selected all
they do is enter the payroll (in the blank field) for that classification. In
some cases there may be some people that will have more than one type of work
performed during that month which they will need to select the another
classification and also enter the corresponding payroll (in the blank field).
I just want all the selected classifications to show on the report with their
payroll. I would like the payrolls from all selected classifications to be
summed.
This would be done monthly and nothing would be stored.
As I said earlier, I now have a combo box where you can select the
classification, but all classifications show up on the report.
Ps: Is their an expression or formula that automatically rounds to the
nearest $ dollar?

Thank you for showing interest--- I value your opinions.

I have a table with 160 records. I am trying to set up my form so the user
can select a record from a combo box, enter the payroll in a text box field

[quoted text clipped - 10 lines]

--

Try to think in terms of tables, records, and fields. Your
description is vague and somewhat ambiguous. If for example, you have
a employee table and want to create payroll records for a payroll
table, then you would use a control that allows the user to select the
employee, and another that allows input of their remuneration. Then
you could add a command button that saves the record to the payroll
table with todays' date. A separate command button could fill a
report table with only those records which have been selected, and
then call a report that gets its data from that table.

 

[OldPro]

I have a table from which the person selects the classification of the type
of work performed during that reporting monthly period. Once selected all
they do is enter the payroll (in the blank field) for that classification. In
some cases there may be some people that will have more than one type of work
performed during that month which they will need to select the another
classification and also enter the corresponding payroll (in the blank field).
I just want all the selected classifications to show on the report with their
payroll. I would like the payrolls from all selected classifications to be
summed.
This would be done monthly and nothing would be stored.
As I said earlier, I now have a combo box where you can select the
classification, but all classifications show up on the report.
Ps: Is their an expression or formula that automatically rounds to the
nearest $ dollar?

Thank you for showing interest--- I value your opinions.

I have a table with 160 records. I am trying to set up my form so the user
can select a record from a combo box, enter the payroll in a text box field

[quoted text clipped - 10 lines]
Try to think in terms of tables, records, and fields. Your
description is vague and somewhat ambiguous. If for example, you have
a employee table and want to create payroll records for a payroll
table, then you would use a control that allows the user to select the
employee, and another that allows input of their remuneration. Then
you could add a command button that saves the record to the payroll
table with todays' date. A separate command button could fill a
report table with only those records which have been selected, and
then call a report that gets its data from that table.

Reports are based on tables and queries of tables. Which table or
query is your report based on? Or is it not really a report, but a
form print? Since one person can have multiple classifications of
labor throughout the month, where is the detail stored? In a table,
or just a listbox? Do you only print one person at a time, or
everyone all at once? If you don't save the details in a table, then
how do you know if it was done correctly?