Search results

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...

I bet you 10$ that Trump doesn't win, evens. Though you should give me 11/8 as trump is ahead in all known polls. :) Any charity of your choice or mine.

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

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

Democrats seem to think that dropping to that level is beneath them, what they do not realize is that in any dirty fight you have to drop to that level, get your retribution in first and ONLY then can they re-write the rules and set the moral standard. I think that it will take a generation to...

@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?

@Minty Thank you. (y)

Good Morning Good People, when I am ranking items frequently the output is not as required, ie 10 1 9 3 9 3 8 4 7 5 I would like the rank to be interpreted as follows 10 1 10 1 9 2 8 3 8 3 7 4 7 4 Is there a global setting that can take care of this...

Good Morning Good People, Can a field name be given an alias in a select statement?

Tongue in cheek, but it seems to me that that is how bananas things could get.

Biden and democrats should be rubbing their hands, Take out five members of the supreme court and replace them Declare the current GOP a terrorist organization and ban all assemblies and political representation, using riot police and prison sentences as required, make belonging to it a crime...