Can I use numbers in my query alias without breaking something? In Expert10.2 Lesson, Richard used MyYear as an query alias. I've tried AsOf1999 and it worked but will the use of numbers set me up for a headache later on say in DLOOKUP? Please advise. Many thanks.
Scott Axton
@Reply 3 years ago
Ruth -
You could as a NAME but you are going to limit yourself in the query(s).
That name is meaningful to you but what if your needs change to AsOf2020 or AsOf1989. See what I mean.
You are better off setting it up more generically so that it is flexible and you don't have to build a ton of queries each time your need change. See the Query Criteria and Value From a Form videos for examples.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.
