Recent content by hkc94501

I want a query that pulls four fields from a table, finds the maximum of those fields and appends that value as a computed field. It seems simple enough and maybe I'm complicating it but I want to do this without writing a VB function. In other words I want it to be done using only SQL and and...

I think you are missing my point. I have a form that does data input and editing. There is a bound textbox that shows the value of an ID field (not the primary key). What I want is to be able to type a new value into that box and have the form move to the record matching the new value. I do...

I have a database with a bunch of data entry forms that are used for entering and editing records. What I want to do is use the form to also search for specific records. Specifically, I have a text box bound to an ID value (not the primary key, just a unique string), call it tbxID. What I want...

Requiring an SMB remote mount seems kinda antiquated in today's cloudy world. I would have done that but we don't have any SMB servers in the company and everybody's remote. We do have Sharepoint but I fear that would be worse than OneDrive. I actually think that the onedrive integration may be...

So I was working yesterday in a coffee shop with free wifi that knocks you off and forces you to log in again after an hour. Access never complained about being disconnected. While I was unknowingly disconnected I continued adding data to the database. The shared backend file is on OneDrive so...

Yes de jure discrimination by race is illegal now but de facto racial discrimination persists. This can be seen in continuing discrimination against blacks in housing and employment. It also persists in private enterprises and organizations not subject to federal anti-discriminaton laws.

2021 - 1619 = 402

I can't tell where your data is coming from or how you compute it. How about posting a spreadsheet? Incidents/population = per capita it tells the likelihood of a random individual being a victim of an incident. Kentucky with a population of 4,467,673 had 241,668 violent crimes that gives a...

Isaac, Thanks for the additional information. I didn't spend enough time on the FBI site. If you were to add in the number of black people killed by police (not listed as crimes) it would about double the number of white on black homicides. I agree with you that 2 parent stable families are a...

I wonder what you do consider a reliable source of crime statistics? The FBI at least is clear about their sources of error and has all kinds of guidance on how to and how not to interpret their data. Perhaps you prefer Tucker Carlson?

Saphira, What exactly are you getting at? I guess I'll just ask directly, Are you claiming that black people are inherently more criminal than others? That is pretty dangerous ground. The notion that black people are more criminal than white has been a key element of white supremacism since...

Isaac, You should take the time to check your facts and reexamine your prejudices. Your uncomfortable truth is a lie. Since this is a forum about databases data should be of interest to readers here. Here is some data from the FBI...

Why is it that the people who didn't have any problem with the former guy negotiating a withdrawal without any preconditions and without consulting the local government in Afghanistan, and giving the Taliban a date for our departure feel so offended when the current guy honors a committment made...

You should do a little research before making an unfounded claim like this. The Challenger disaster was not caused by cheapest bidder O rings, it was caused by a management decision by NASA to launch against the professional advice of the engineers at Morton Thiokol. If you would like to learn...

Nonsense! Democrats do not ignore gun violence in black communities. Consider that black communities are predominantly (exclusively) represented by Democrats and Democrats are leading the charge on gun safety. Now I will make a generalization. People who make claims like this tend to believe...