Recent content by nighthawk999

Insulting is always good. I've figured it out, I think I was probably explaining it badly and you got the wrong end of the stick. I can just put an OR throughout the entire query on each field/criteria. Thanks for all the help, frustrating I imagine but there you go that's why we're noobs and...

Yes that's exactly what I meant, because if I do the criteria as just "yes" with update to "Commercial Quotes" then add another one in the next column with criteria as "yes" update to "cover notes" It treats that as an AND. I really need it to be OR's. So putting that Expression in the...

Ahh so I can use the GUI query builder? And then in each row I put this expression?

That's what I already have. Hence my original question hehe I have about 30 different update queries to clean up various fields for each record so I can then upload. My question was, is there a way I can do an 'all in one' update query because doing it through access if I use multiple fields...

The Table has 39,000ish records. Basically I get a download of data from one source, which needs tidying up to be able to upload into another source. Some of that 'tidying up' means I have to update fields en masse. So changing the Commercial Quotes field for example from Yes to Commercial...

The table consists of User Name Address Address 2 Commercial Quotes (which can be a Yes or a no) Cover Notes (yes or no) Personal Quotes (yes or no) And various other things which'll be yes or no. I can't see how else you'd handle that?

I should of added, I have a little SQL knowledge and a little Microsoft Access knowledge and zero knowledge about things like creating procedures etc. I know the theory just never done it in practice so wouldn't even know where to start. I'm assuming this is now dipping into advanced stuff? or...

I have one table, I want to update multiple fields in that Table with values. Currently I have on update query for each update. So for example Rows: Commercial Quotes, Cover Notes, Personal Quotes Will have the values: Yes, No, Yes in them. I need to update those fields, if they say Yes to...