Hi. Was wondering if the order of fields in a query would impact the speed of processing, esp. if the query is on the front end of a split database?

Thanks.

Russ

while i haven't tested specifically for it, i don't think the order of the fields in a stored query makes any difference...

making sure that you have indexes set up in your table design for appropriate fields, does, however, have a major impact on speed.

hth,
al

Only if your doing some kind of grouping or using functions or expressions in your fields.