Recent content by webware

I am running the following query and want to know how to display records 4 thru 8 SELECT house.P1, Count(*) AS EXPR FROM house GROUP BY house.P1 HAVING (((Count(*)+1)<>False)) ORDER BY Count(*)DESC;

thanks that worked!!!

I am running the following Query and was wonder how to add to this in order that I can display the first 3 and last 3 records. SELECT house.P1, Count(*) AS EXPR FROM house GROUP BY house.P1 HAVING (((Count(*)+1)<>False)) ORDER BY Count(*); Thanks to anyone that can help

I need to create a search that will list a 3 digit # that is listed more than once. The catch is if the # found in the table was 302; I would also need the search to recognize that 203, 320, 230, 032, and 023 are the same as 302. So the results should show 6 occurances for that #. I hope I am...

I need a query or maybe vbscript that will search my database without having a user input a # for a 3 digit # in any combination that was most freaquently used,2nd most freq. etc. for example: if the database contains 7 entries 325; 352; 235; 253; 532; 523; 234, the output should show that the...

I need a script that will search my database for a 3 digit # in any combination that was most freaquently used,2nd most freq. etc. for example: if the database contains 7 entries 325; 352; 235; 253; 532; 523; 234, the output should show that the most freq. used was 3 #'s containing 325. Can...