Help with some SQL

[swisstoni]

Hmmm, well I've had a quick scout, and none of my big queries are using OR's.

I've also looked again, and the query I've got above isn't actually slow at all when you load it in datasheet view.

But its within a subform with conditional formatting setup to see whether shelf stock > allocated stock, and theres a BIG delay when flicking between records..

So might appear that it's not the query, but just Access being hellishly slow with conditional formatting?

 

[jal]

Hmmm, well I've had a quick scout, and none of my big queries are using OR's.

I've also looked again, and the query I've got above isn't actually slow at all when you load it in datasheet view.

But its within a subform with conditional formatting setup to see whether shelf stock > allocated stock, and theres a BIG delay when flicking between records..

So might appear that it's not the query, but just Access being hellishly slow with conditional formatting?

I don't use Access forms because I use VB.Net forms. I know nothing about conditional formatting.