Search results

I'm not sure if your question is academic or if you're approaching tentatively asking how to search and show few records at a time. An option, pending clarification, could be a form with search field and max number of records to show...??? Reports are for print typically.

?? Why would/could Investments01_tbl.Stock_Name be Null? SELECT Investments01_tbl.Symbol_Stock, Investments01_tbl.Stock_Name, Investments01_tbl.Investigate, Investments01_tbl.Trade FROM Investments01_tbl WHERE Investments01_tbl.Investigate=Yes OR Investments01_tbl.Trade="Purchased"; Query1...

Welcome to AWF!

Is Sales.Price Currency datatype?

Generally you would run a query to calculate the total. You would not store the total in a table. You would put the Total value on a form or report as needed. What is the ultimate goal? What additional calculations?

asteropi, You seem to be focused on manipulating text box contents. I think it would be helpful to you and readers if you told us more about WHAT you are trying to support with automation. You mention Customer code and Customer type... and that suggests to me some business activity involving...

cheekybuddha/David, Do you have a sample database using Dymeng/ Jack Leach's JSON Parser that you could share?

Welcome to AWF!

I agree Paul. However I was just working with your sample You could devise logic to deal with numeric street address. eg Split and process substring...

Perhaps: More than 999 and Not containing a comma.

Welcome to AWF!

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.