Relative Content

Tag Archive for vbaado

How to merge these 2 select statements into 1 statement in ADO?

I have 2 Select statements that I need to have both in 1 statement to avoid the manual lookup I do every time updating the Data sheet to determine which account is above 250 K and which is below 250K. Please take a look at these 2 statements:
Once this routine is completed, I look up the Temp sheet and update the data sheet with the above 250 or below 250 categories. If there’s a way to merge the second statement into the first one(vsql), that’d be much appreciated.