Great, don't forget to upvote posts that help you ;)
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
In a LAN with multiple computers, a few machines installed MySQL you can use the command line in cmd.exe (or any software) to know how many LAN computers are not installed MySQL ? for example in SQL Server have command line: osql -L
This article [^]may help, it is designed to work with SQL Server, I don't know if it will work with Access. It requires 2 nested queries, fist prepare your data so you have exactly what is required (join the table) and get the column names to pivot on (Date/Times). This pivot the data on the date/time column.
Never underestimate the power of human stupidity RAH
Procedural coding is about procedures/functions. We write procedures which just take an input and produce an output. They don't have any kind of relation with another procedure. Sometimes they are just able to use some global or shared data when required. OOP is all about objects. We do write procedures/functions in OOP, but the main thing is the class. A class has a relation; it can be a parent or base class, it can be a child class. And then we do things on the objects created by those classes. As classes have relation so we can say that the the objects of those classes do have the relations also. For deeper understanding, you should check for articles online. Just google :)
Thanks Richard, It would not be possible for ABC to exist in Person1 and Person2 in the same row, but its no harm using the syntax you describe to circumvent it in case it were to happen.
The IIF function was added in SQL 2012[^]. If you're using an earlier version, you'll need to replace the IIF function with a CASE block[^]:
Sum(CASE
WHEN gender = 'Male' And age >= startage And age <= endage THEN 1
ELSE 0
END)
You could also simplify the age condition by using the BETWEEN operator[^]:
Sum(CASE
WHEN gender = 'Male' And age Between startage And endage THEN 1
ELSE 0
END)
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Thank you for taking the time to write that reply. I will dive in with your suggestions. - Patrick
Thank you to anyone taking the time to read my posts.
This thread [^]turned up when I searched Google I have the same setting on my local machine but I don't need Agent so have never enabled it!
Never underestimate the power of human stupidity RAH
It can be difficult to get into the jobs market just based on a qualification so my advice when starting out is take a job that you will generally enjoy - if you make money a defining criterion for your first job you are probably going to find difficulty in getting a job. Be prepared to work your way up - starting in a shop(which is what I did) is not necessarily a bad place if you keep your IT skills up to date and help out where you can in IT/database/programming.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
