----------------------------Original message---------------------------- I have designed a database which contains spatial data using Dbase IV for DOS 2.0. I have written three programs in the Dbase IV programming language to assist in extracting information from this database and then importing it into a GIS. I have found that Dbase IV is more difficult to learn for my employees and interns, so I have decided to begin using Microsoft's Access 2.0 for Windows RDBMS. I am familiar with most aspects of Access. Here is where I need some assistance. I am in the process of learning AccessBasic. I have written all of my Dbase IV programs in AccessBasic except one. I realize that this may not be completely related to GIS, but it does have something to do with managing spatial data prior to displaying/analyzing it with a GIS. Here is what the below mentioned program written in Dbase IV language does: I use a database named temp1.dbf and I want the information that has been processed to be transferred to year93.dbf . Select 1 Use temp1 index temp1 Select 2 Use year93 Select 1 Go Top DO WHILE .not. eof() Store 0 to Freq Store Grid to xy Do While .not. eof() if Grid = xy Store Freq + 1 to Freq else exit endif skip EndDo Select 2 append blank replace MapGrid with xy, Frequency with Freq Select 1 ENDDO What this program does is count the number of times a grid number (e.g. 432A7, 543H9, 213K1, ...) occurs in the field GRID in the temp1.dbf then it saves this information to the year93.dbf as two fields MapGrid (e.g. 425E2, 254H9, 673D1, ...) and Frequency (343, 78909, 1213, ...). Frequency will show the total number of times each grid number occurs in temp1.dbf. I hope someone can help me (or show me how to) translate this program into AccessBasic. Thank you. Sincerely Timothy S. Hayes Chief Cartographer Medical GIS Consulting Services [log in to unmask]