Search results

Where does a fish work? Inside an offish. What is the stinkiest planet? Uranus. (Don't ask me why. Even I don't know~:ROFLMAO:)

Interesting. If ACE is a specific version of JET, does that mean Access really is powered by JetSQL, not AceSQL?

Here’s the sample month column I need as an output. Microsoft website states that the use of MonthName(Month, [abbreviation]) is the right way of converting numerical to word context, but I can’t seem to make it work under the SELECT statement.

Let me try uploading a photo of the sample output:

It's OK! No rush~ I know how busy you must be at this time. I thank you for doing your best to assist!

I believe I recall it was JetSQL. For now, I plan to do a single column showing all of the months in word format. The PIVOT shows separate tables from your OsMan example. Might I ask if the guide from sql-practice or W3Schools actually helpful in learning MS Access syntax? Most of the other...

Didn't expect a fellow Filipino here! Hey there! Let me check the query of OsMan. For now, isn't MS Access powered by JetSQL?

Hi, Minty! An update to your suggestion: I have a syntax error with the FORMAT and WHERE part. I forgot to share that I'm using MS Access 2019.

Interesting suggestion! Let me try this out~ thanks!

Hello to everyone who's in the query forums! I'm a new user here. Really new, that I have to ask if it's possible to do multiple MonthName() in a single query. I'm trying to produce an output where the numerical months turn to MonthName(), but alas. Only 1 month is being shown. Here's what...

My first day here feels welcoming! I was greeted by a friendly staff member! I really hope my stay here while I start my IT journey be fun and worthwhile.

My name is Timothy, but everyone calls me "Tim" from the Philippines. I just career shifted from a Hospitality degree to an IT one. Currently enrolled at a Masters in Information Technology and is new to the world of MS Access. I may post questions and answer some at selected forums from...