using UCase in queries

February 19, 2009 at 16:43:57
Specs: Windows XP
I need to use UCase in a query in Access 2007. Can anyone tell me how to set this up?

See More: using UCase in queries

Report •


#1
February 19, 2009 at 17:29:49
Don't repost, but you'd probably get more help if you had posted in the Database Forum.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

#2
February 19, 2009 at 20:25:23
You know, that's the interesting Catch 22 of this website.

We're not supposed to repost, so if we ask a question in the wrong forum, we get an answer that says we should have asked it somewhere else. Oh, but BTW, we're not allowed to then ask it in the right forum.

Seems kind of harsh to me. You make an honest mistake and you're out of luck - no second chances. That's pretty rough.


Report •

#3
February 20, 2009 at 05:22:11
Not my rules...Just trying to help. The option is there to PM Justin Weber and ask him to remove the original post. Then, you can repost.. :)

Making sure it's in the proper Forum the first time eliminates the need for that special request, and you'd probably get assistance much faster. :)

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

Related Solutions

#4
February 20, 2009 at 08:37:12
re: Making sure it's in the proper Forum the first time eliminates the need for that special request, and you'd probably get assistance much faster.

OK, then what is the proper forum for an Access question? One of the subcategories when posting to this forum is Microsoft Office. Below is a list of the applications included in Microsoft Office. Note the first product in the list.

One could contend that this is the proper forum for an Access question, but it appears that Access has been singled out as a Office product that doesn't belong here.

So a user posts to what would appear to be the proper forum, but then has to submit a "special request" to have his post moved to a different one.

Sounds like there's room for some process improvement here.

Here's the list of products included in MS Office.

Access
Accounting Express
Excel
Outlook with Business Contact Manager
PowerPoint
Publisher 2007
Word 2007


Report •

#5
February 20, 2009 at 09:25:26
Access is Database software.. I'm just trying to tell you that people who are experts in Access might not frequent the Office Software forum.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •


Ask Question