Search results

What DISTINCT field(s) exactly? Here's an example SELECT DISTINCT Country, City, PostalCode FROM Customers; See this from w3schools.

sleepy11, How consistent is your data? Are your addresses formatted in a standard/consistent manner? Your request is interesting, seems a local requirement rather than a Canada Post formatting need.

Welcome aboard AWF, Tom! Lots of us old, retired guys here.

akk303, My point on 'business process(es)' was intended for you to provide an overview description of WHAT you are trying to automate/support with a database. I can remove the term business from the post and emphasize the what is the subject matter and what are the relevant steps involved...

I think it would be helpful to you and readers if you could step back and provide a 30,000 ft overview of the 'business process(es)' you are trying to automate/support with a database. Use simple plain English.

See this AppInventory article by Allen Browne for ideas and insight.

I recommend you show the SQL for the queries. Or, better still, provide a copy of the database with enough data and instructions to repeat the queries.

Without some examples and not clear on what similar entails, I googled some attributes of Product.

Good one Doc! Reminds me of one I heard years ago. The setting is the introduction of roads and rules, We're introducing the rule that cars must drive on right side of the road..... and if this works well, then in one year we'll adjust to apply same to trucks and motorcycles.

Richard Rost has a multi-part youtube series on an Association database suited to Groups, Clubs, Churches...etc. It may offer some insight on structure and requirements. The first video is here.

wmix, If you provide the table structures/designs including indexes, and the SQL for the query(ies) involved, I'm sure you'll get focused responses. The critical factor/concept is what field or combination of fields in your query make(s) each record unique. Since you have "duplicates", some...

Tony, I totally agree with power needs of the LLMs. I think her comments highlight the "we must all move to EVs to protect the planet (by date xxx)". Where I live (rural Ontario), we can get power failures from time to time-mostly with high winds/storms. The underlying issue is the full lack of...

Hello and welcome to AWF, UseKee!

Here's an example StrConv ("TECH ON THE NET", 3) Result: "Tech On The Net" Parámetros o argumentos texto La cadena que desea convertir. conversión El tipo de conversión a realizar. La siguiente es una lista de parámetros válidos para la conversión. Descripción del valor del...

I have at least 1 site where it is automatic 2 factor authentication and I can get requested to answer a question ( 1 of 3 or 4) that were being used before 2 factor was initiated.

Good point Jon, but I expect the scammers will find a way to infect those new tools and cause havoc. I don't foresee a steady, positive state of things. Let's hope there's more good than harm. I'm thinking of recent articles about new drugs/cosmetics, batteries... only to see that there are...

I think Doc has it right. For a little side entertainment you may find this by Sabine Hossenfelder interesting.

Isaac and Tony, et al The more I attempt to use Chatgpt and CoPilot(Bing Chat) productively, the more I am becoming convinced that the major beneficiaries of these tools will be/are the scammers. As with a lot of technology, the "bad guys" have an intrinsic knack for making the best/worst? use...

Did you try the query I suggested in #4? It should show the unique values in Category.

I agree that readers need to see your table design and some data. Is it possible there is a spelling mistake? You may try Select distinct Category from Contact_People; to see existing Categories.