Auto fill help

[Ternick]

I made a database to help my tow company out and need help with my payroll button. I need it to run the report, then after running the report change the Paid to Driver field to yes and put in the date for the next payday. I have a query set up to show all invoices that haven't been paid before or on a set day and don't have the time to mark 100-300 invoices as paid to driver and what day we are paying it on. I don't want to have all invoices marked as paid to driver when I click on my payroll button, just the ones in the report. If I need to change how my payroll is displayed I can do that.

[ItsMe]

Are you managing payroll or are you managing vendors? Have you tried creating a query using the Query Designer?

Before you create an update query, be sure to make a copy of your DB, create and test you update query on a copy.

You can use tools there that will update fields within a table. Just click on the Update tool within the Ribbon while in Design View of your query. Then you can add the 'Paid' field to your query by adding the table to the design area and adding the field by double clicking it. Then type a value in the update field within the grid and for the proper column. Add other columns by double clicking the field name from within the table. Use additional columns to include criteria that will limit the records retrieved by the query.

[Ternick]

Itsme you are becoming very helpful. I had no idea queries could do that. I'll mess around with it. In this case I'm trying to manage my payroll, I have it set up to calculate how much each driver gets paid for a tow, if it is ready to pay to the driver and if the driver has been paid.

BTW I somehow have two accounts on here and t

[ItsMe]

When you build a query using the query designer, it will generate SQL. You can view the SQL by switching from design view to SQL view. It can be helpful to understand and maybe share your SQL with others when trying to solve a problem. Also, you can employ SQL statements in places like Forms and ComboBox controls.

[Ternick]

Thank you Itsme. I had to have 2 payroll queries. One is for the report, the other is an update query. With the button I set it to run the report first, then run the update query and it works great. I have no option for SQL view or I would add what it has. Thank you for the help again

[ItsMe]

While in Design View of your Query Object you can switch between Datasheet, Design, and SQL view. The View button is located within the Ribbon, under the Design tab/group.
.