Search results for query: *

I need to query a table that contains a hundreds of clients. The query consists of pulling out the Top 10 or Top 30 clients as per volume. I can do this by the Count Function but this provided me with all of the clients with their volume. How would I retrieve just the Top 30 for example?? Thanks...

Even though the level of Sypport will change. The certifications provided will still have value. I am saying this regardless if you have the experience or not. I believe that a W2K MCSE is still a very valuable certification to have. Chucky

I'm doing my MCDBA in the UK at the moment and I have understood that they will stop providing support in January 2003 in Europe. This is for the roll out of .net. This does not mean that this will be a problem for certification. Just means that your MCSE or whatever will be in Win2000, the...

Sorry to bother you guys again but the Query I am running has some problems. Would the Query not function as well if the table I am looking at is reasonably large, 9000 items? Or possibly using Upper or Lower case. I am having problems with bringing back the correct criteria when inputting the...

Thanks Guys it worked. That was excellent. Much appreciated. Chucky

Mike, thanks for taking a look at this. The SQL is below SELECT ICT_ICT_TRANSACTION.SCHEDULED_TERMINATION_DATE, ICT_ICT_TRANSACTION.CHARACTER_4 AS REF_ENT, ICT_ICT_TRANSACTION.BOOK_CODE FROM ICT_ICT_TRANSACTION WHERE (((ICT_ICT_TRANSACTION.SCHEDULED_TERMINATION_DATE)>Date()) AND...

Sorry Mike it didn't like the Syntax. Have you any other suggestions? Chucky

thanks for getting back to me. but unfortunately neither of these options worked. thanks

Hi, I am using MS Access and running a Query on a Text Field using a Parameter. The Text field in question can contain many variants of a name. For example Republic Brazil Republica Brazil Republica Brazil SA I would like Users to be able to Input into this parameter box; for example 'Rep'...

For some reason if a new Administrator profile is created on my XP machine, it does not provide me with Admin Rights on my PC. This has stopped me being able to install new software (Norton Anti-Virus) as it claims I am not the Administrator and also changing data for example the PhoneBook File...