Search results for query: *

pwise, The latter code works! THANKS!!!!!! Now I need to work on the next piece....this analysis is something new we are doing and trying to get the desired results for my vp. I need to take the total number of IP entries ( 8 in my example) and provide a percentage of IPs for each category of...

My database currently has two tables Range (fromrange,torange) – range of possible values – manually built into table in Access 0 10,000 10,001 50,000 50,001 90,000 90,001 999999999 iptable (IP,Usage) – Generated from...

putting in exactly what you suggested Select fromrange,torange, count(*) as countinrange from range left join iptable on Usage between fromrange And torange group by fromrange,torange

still generates the same error....darn thing!

Now getting following error Between operator without And in query expression 'Usage between fromrange'

I caught the missing comma when looking at it more. Now getting another error Between operator without And in query expression 'Usage between rangestar'

that is what I did yesterday and received error. Syntax error (missing operator) in query expression 'torange count(*)'

Ok so I have the following tables Table - range fields- fromrange torange 0 10,000 10,001 50,000 50,001 90,000 90,001 999999999 Table -iptable fields - IP Usage 192.1.1.1 5,000 192.1.1.2 10,500 192.1.1.3 12,000 192.1.1.4 83,000...

pwise Looking to count generated usage value based on table. I understand that the table needs to be created. The part of relating the file to the table and generating the counts is where I would request more guidance. This is probably really easy but just not sure how to accomplish. Thanks!

I need help in determining the best way to count how many IP’s fall into categories based on usage value. I am using Access 2000 to accomplish. Groupings – Put into a table? Best method? 0 to 10,000 10.000 to 50,000 50,000 to 90,000 Over 90,000 Data Output from external system that needs to...