Naming Queries

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

How do you guys name your queries that you create to be used for other
queries? I have a hard time remembering what the purpose of some of my
queries are.

Thanks,
Linda
 
If I have a set of queries that need to "bundle" together, I tend to use the
naming format"

q{PurposeOfTheSet}_StageI

where I is 1, 2, 3, ...

This way, when I sort the queries by name (ascendingly), they stay together
and I know that the later stages will use (some of) the early stages as
DataSources and to achieve the purpose of the set, I need to run the last
stage.

A consistent naming system that is easier to remember for you is probably
the best method for you!

HTH
Van T. Dinh
MVP (Access)
 
I prefix all my queries with qry or somthing like that so I know it is a
query

so I would come up with something like qryClient_Overdue_30_Days
 
Back
Top