Please ensure you are selecting the compulsory Surpac fields such as hole id, x,y,z, max depth and hole path fields.Ĥ. Double click on each of the fields you want in the collar query. Click on the Create Tab, and create a query using the collar table.ģ.
Open up your database in Microsoft Access, making sure that this database is closed in Surpac.Ģ. The below steps will explain in detail how to filter out such drill holes.ġ. Surpac can then be mapped to the resultant collar table. This type of filtering can be done easily through Microsoft Access, and then viewed in Surpac by creating a Make Table Query.
To do this a wild card “*”, needs to be used in GEOVIA Surpac. When reviewing drill holes in an ore deposit that has been drilled over decades, by several different companies, geologists may want to filter out the holes based on the hole ID which is generally different for each company and can also signify the different drilling methods.
