Search results

Thanks Pat, got it working-much cleaner this way.

Thanks for the suggestion. To make sure I understand correctly, I have done the following: Created 6 queries using the tables - tblJobs,tblNames,tblJunction. Fields are tbljobs.jobid,tblJunction.projectid, tblNames.name, giving projectid an alias for each job role. I then created a query using...

Thanks to all of you-it worked! I've been struggling with this for weeks! I appreciate your fast responses and clear instructions. Toni

Like this? (Still a rookie) I have this in the Before Update event of my form: Dim db as DAO.Database Dim rs as DAO.Recordset Set rs = db.OpenRecordset("SELECT Min(AssetNumber)AS A FROM Assets WHERE IsNull[DateAssigned]") How do I tell it to put that value into the "AssetNumber" field of my...

I would appreciate it if someone could look at my code. I just need a "WHERE IsNull" statement and cannot figure out how to do it. On the Before Update event of my form I am grabbing the next available "AssetNumber" from my table "Assets", but want the next Min "AssetNumber" where the...

Finally getting back to this project. Here is what I have so far which isn't working correctly: table Assets has AssetNumber, DateAssigned table "AssetNumbers" has DateAssigned, AssetNumber, and additional information that will be appended to it from the RequestAsset form My goal is to have...