Search results

Yes. I just needed guidance on this. I'm not actually asking for the right answers.

Late reply, buddy but thanks for the welcome!

Good day, everyone! I have this new project where I need to turn these scenarios into a DB with ERDs by CREATE DATABASE/CREATE TABLE without typing any actual queries, but all tables are in a one-to-many relationship: I need to set associated primary keys and foreign keys to each other...

We actually needed the JOIN function? Noted! Thanks!

The 1st 2 queries are done, thanks to your amazing support! Is counting the number of admission by year from every province like this: SELECT Year([admission_date]) AS [Year], province_names.province_name, Count(admissions.patient_id) AS Total FROM province_names GROUP BY...

This will be most helpful! Thank you so much!

Isaiah 60:22.

With cheese grates as torn skin for added falir~

I’m supposed to follow this relationship table. Now, I ponder where to get MonthName(). A close professor of mine just stated that I just need 3 statements: COUNT GROUP BY ORDER BY

Here's the full DB I'm trying to identify. I can't seem to zip it, so I'll send the file here directly. I have 3 queries to work on: a. Counting the number of Diseases by Year. b. Counting the number of Admission by Year and Month. c. Counting the number of Admission by Year from every Province.

Thank for sharing, ebs! A rather strange part is that I have no table for the month of the admission date within the relationship.

SELECT Year(#11/3/2023#) AS [Year], MonthName(1) AS [Month], Count(*) AS Total FROM admissions GROUP BY Month([admission_date]) The output is a blank query. Might I ask why the 'MonthName(Month(admission_date)), Month([admission_date])' part?

Doesn't happen to mine! Could be a bug in the system. If it happens occasionally, have you tried deleting and reinstalling Access? It sometimes works.

Thanks again for responding! I also had this syntax error with the MonthName() part where it states the message: "Your query does not include the specified expression 'Month(admission_date)' as part of an aggregate function." Which is strange because I have an 'admission_date' on my...

And I thought "Impostor Syndrome" was every IT's worst nightmare~ :ROFLMAO: I'm still at the learning phase, but coding drains me out so much. I just close my laptop, walk to my bed which is only 2 steps away from me and take a power nap and a prayer.

This it the reason why I'm taking my Master's degree: I don't want to work for a company. I'd rather teach what was taught to me during my Master's life to undergraduates and postgraduates. For now, I, myself am a Masters student who got career shifted from Hospitality to IT.

But until the time ChatGPT gets updated with a DB after 2021, it might get overthrown by Bard.

That's new information for me! Thank you! Same goes for you, @arnelgp !

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?