Search results

Hmm...I could use No# as a unique identifier. It unfortunately, also has text. Example of that data is "SO0725982". Yes the data is from another system I have no control over.

Thank you all so much for your help. The ID in this case is the job number unfortunately. The fields arrive the way they are and sadly have to stay that way. There are many other air card brands with their own fields, but Verizon can be substituted for ATT and visa versa and quite often are...

Much more elegant. I'm getting a Run-time error 3061. Too few parameters. Expected 3. Thanks for though. It gives me a good jump off point to work with!

I added the space after Top. I use Q2 and Q3 in the following queries. I wasn't getting what I wanted and was trying to break the queries into step by step..... The logic I attempted was: Q1 filters to Job No# (stuck with that field, not my choice). Q2 selects the top 624 from Q1. Q3 updates...

I'm not good with vba. It's just the only way to move the records from one field to another. What I have is 704 records with fields Job No#, ATT and Verizon. The Job No# is isolated by in a subform and ATT has a number 1 in it and Verizon has a number 0. I need to change 624 records to be the...

I'm trying to write a query that takes the job number (existing field) and the number of records field, NbrRec (typed in number on form) and updates ATT to 0 and Verizon to 1. I have 704 records that match the job number and I enter 624 in NbrRec. I would like only 624 of the ATT records updated...