naming queries, getting past 9

[hazell]

Hi all.
I am writing some queries with a fairly complicated naming system and have hit a snag.

The naming goes like this:

QM H 1 32 etc etc
QM H 2 32 etc etc

down to

QM H 10 32 etc etc

And the query jumps up the list of queries. How can I get access to recognise it as 10 and not 1.0. I cannot move the queries manually.
Hope you can help as I am writing a lot of queries and they need to be in order

thanks for your help
Hazell

 

[pbaldy]

The need for for all these is a bit suspect, but padding with zeros will correct the sort:

QM H 01 32 etc etc

 

[spikepl]

Paul is onto something - if similar queries exist but just with different name, then normalization is in jeopardy. And then the normalization nemesis will hit you - huge extra maintenance of data, queries, forms, reports and code.

 

[hazell]

Drat! Should have remembered the 0. Thanks so much guys you've saved me hours of headscratching

 

[pbaldy]

No problem. Curious why all the queries. Maybe we can save you a lot more grief.

 

[SOS]

Curious why all the queries. Maybe we can save you a lot more grief.

That makes me wonder too. It looks like a lot of queries with different parameters in each or something and that can usually be whittled down considerably. Hazell - I would let pbaldy and spikepl help you with that. You probably don't need all of those.