Search results

This has just work for me in the CRITERIA section of the field >#01/01/2010# And <#01/01/2025#

dont have the program

My tables are DBF files

Good Morning Good People, First of all I would like to thank everyone for a really interesting discussion on this topic. I have come to the conclusion that people are both FOR and AGAINST censorship and free speech. Secondly, It appears unanimous that children should not be subjected to the...

@ebs17 Thanks for that Eberhard, I have downloaded the server and had a look over it. My goodness it is daunting. ACCESS is now looking like a comfy old Sofa. :)

Good Morning Good People, Thank you all once again for your considered and helpful replies. I am in the process of having a rethink on the back end data by breaking it down into my own database with a smaller more appropriate data set and and going from there. One more quick question if I may...

Hello Cheekybuddha. SQL for FTQ21 is as follows SELECT FilterTable2.odate, FilterTable2.OrderId, Sum(FilterTable2.UnitPrice) AS SumOfUnitPrice FROM FilterTable2 GROUP BY FilterTable2.odate, FilterTable2.OrderId; Thanks for your input.

hello Pat I was previously advised that DCOUNT was the way to go. This is my SQL SELECT ftq21.odate, filtertable2.orderid, ftq21.sumofunitprice, Dcount("*", "ftq21", "sumofunitprice >=" & ftq21.sumofunitprice & " and odate = " & Format(...

Thank You all for your not inconsiderable effort, help, solutions and replies! (y)

@jdraw I can follow the logic there apart from "TTid" Would it be possible to create the Table and run the SQL to populate it? It means learning something completely new and it pleases me that you think I am capable of that, but I have only just got it working after several weeks of...

I am sorry Jdraw but I have not a clue what the process is that you are trying to explain to me. The make table query puts the fields into the table. I have to manually add the auto number field as the next query will not run without that field. I just thought, rather in hope than expectation...

if I run the second query from the first it is very slow, 1.7 million lines with 2 Dcounts. If I make the table first the second query is much faster as it doesn't seem to have to recalculate first query. I used the table, rightly or wrongly, to "fix the data" so it runs faster in second query

I think That I have probably used incorrect terminology. I need to create the field LSR_ID into the table.

Good Afternoon Good People I use a make table Query to make a table which I then reference in another query. To reference the table in the subsequent query I need to manually add an auto index field. Is there anything I can add to SQL in the make table query which will add and auto index field...

A man walks into a bar It was set too low..

IT would be nice if we could Vote A and B.

@ebs17 Danke Eberhard, Mein Deutsch war noch nie besonders gut, abgesehen von der Analyse guter deutscher Biere ist Doppelbock mein Favorit. Mit Hilfe eines Übersetzers konnte ich Ihren ausführlichen Beitrag lesen. Da sind einige tolle Tipps dabei. Vielen Dank, dass Sie mein Verständnis...

I suppose that is why there were errors. I went back and removed the alias from all statements. I need to learn what is happening in what order.

I will try suggestions Thank you for advice (y) The penny has dropped with the "select Distinct" (y) Eberhard you are always right.

thanks @arnelgp the rank is generated in a query. should I let it run, and then a new query to convert or try to modify in the query?