I need to use UCase in a query in Access 2007. Can anyone tell me how to set this up?

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

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.

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

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

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