3075 missing operator

[Mark_]

OP,

Query for you, are you changing your file's format? I noticed you are referencing different fields in your code examples. Also, why reference by Field rather than using the field's name?

Referencing by Field is far less obvious in code than using the fields name, and can easily lead to using an incorrect function or improper formatting. Horrible when you accidentally format your BalanceAmount as a date for use...

 

[Pat Hartman]

Those ARE his field names. One problem to fix at a time

 

[Mark_]

Pat, if they ARE his field names, why are they changing? That is a giant concern to me...

 

[chizzy42]

Again thanks for taking the time to feedback on the code. The field names aren't named yet as there hasn't been a decision made on the data being fed in(the data is brought in by a form that searches network locations and loads it into a table...it works for me but the coding would probably give you chills). All I'm trying to do here in this code is find a way to allow blocks of data within week numbers to be used for yield purposes... field8 is a column that contains pass or fail.
Hopefully after spending more time here with people who are pros at this, ill get a bit more slick at SQL/VBA