Search results

Thank you for your comments, I have a lot to digest. I'll post an update this week when I get a chance to investigate the options further.

Looking for suggestions on how to correct an issue I've been running into while trying incorporate a automated work assignment tool. The database is pretty simple, I use a series of recordset updates (see code below) to randomly assign users to workloads based on age and proximity of the users...

Sorry it has been awhile since I have checked out this thread. I have been traveling and I put this project temporarily on hold. Thank you for your suggestion PLOG, that worked exactly how I wanted it too. Below is my SQL to memorialize if anyone else in the future is having the same issue...

I put dummy data in the attached spreadsheet. A. Tabs "Sizing" and "Reviewed" are the tables. B. Tab "Query Results" is the query.

Or perhaps try this? Val([IRNzCount])+Val([U1NzCount])

Is your form field TEXT instead of NUMBER?

I'm very new to SQL and I am having a heck of a time figuring out how to design this query. qryRackZeroOHB references two tables: Sizing and tblRackZeroOHBReviewed. This query will run daily and append into tblRackZeroOHBReviewed once the user enters the relevant information into the [Action]...

So I have made a lot of progress regarding the workload assignment tool using a series of recordset updates but I am stuck on one major hurdle. I have a "Complete" button that users press to signify a completed workload and the query runs to automatically assign a new workload. My problem is, if...

That did the trick, thank you sir!

Right, but where would I input the SQL statement from the other table? I'm trying to populate ![LastZone] with the return value of my sql3 statement. This is my code now which doesn't return a value. Private Sub btnCompleteWorkload_Click() On Error GoTo ErrorHandler sql2 =...

Thanks for the responses...I think I'm on the right track using recordset but I'm stuck on one part. Below is my code. Basically I want to update the [Last Zone] with a value that is from my tblOpenWorkloads. Private Sub btnCompleteWorkload_Click() On Error GoTo ErrorHandler...

Long time reader, first time poster...I am somewhat of a novice at Access but I believe I have a relatively non-novice problem. I am trying to create an automatic work assignment tool but I am having trouble conceptualizing exactly how to design it. I have the following queries...