Search results

I know, I had it about 30 years ago or more, when it first came out. It might still be buried in the loft somewhere.

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

Thats because you didn't vote last time. He He! I visited a Garage a couple of years ago and they had just had 11 scania trucks at 76k each stolen in one night, all electronic. The thieves have the technology as the Main Dealers. Faraday cages for the trackers and jammers ensure there is...

Everyone is already in the NRA, just not all decide to buy a gun.

It should be compulsory to vote. Refusal to take part in the democratic process should result in restriction in use of available services that a democratically elected society provides. No Passport to be issued - waste of time plane might crash No driving License - waste of time car might...

He is so far ahead of the game it is unreal.

I am not saying that I agree with it or that it is justifiable, merely that it is the case. Probably the reason trump is revoking abortion and contraception rights, he wants White ethnicity population growth for the reasons you have identified. The main problem that we face is that big business...

The American situation is more complex than ours although similar. Big Business demands ever increasing returns and growth for their profit margins, but where does this growth come from? If I want to expand my business I need to recruit new staff continually over the next n years. The...

The country was lied to, they were told that we would be better off and put more money into the NHS, Stop immigration. Half the country new that Farage et al were totaly fabricating a case for leaving and the other half fell for the lies. No extra money for NHS Immigration up GDP down Growth...

Farage Is the worst thing to come out of the election. He will think that he has a roadmap in Trump. The elements that he will try to wrap up into a package that he thinks will be acceptable to the gullible public are the usual, Racism, Immigration, terrorism coming into the country. He has...

Voted for by Britain's Looney Inhabitants. The real success in the election, IMO, is that real Conservative voters have sent a clear message to the party, that the likes of Rees-Mogg and the personality driven divisive cohort that EXISTED behind the scenes is unacceptable to most normal, right...

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