C
CJ
I'm going to try and be more specific. I have a few
tables with info. The first table gives Grid ID's like
A01 and B01, etc. I have another table that gives local
coordinates for each corner, like SW_x,SW_y, NW_x,NW_y,
NE_x,NE_y and it gives these for each grid. I have a 3rd
table with geo coordinates. This tables gives Northings
and Eastings for each corner.
I want a query that will allow me to type in the grid B01
and show many a table with 16 results. It will show SW_x
and SW_y of the SW,SE,NW,NE corner. It will also give the
East and North of the SW,SE,NW,NE corner of that grid.
When I make a query and say to [Enter Grid_ID], I get 80
results instead of the desired 16.
If someone would like to help me, I can e-mail the tables
if that will help
tables with info. The first table gives Grid ID's like
A01 and B01, etc. I have another table that gives local
coordinates for each corner, like SW_x,SW_y, NW_x,NW_y,
NE_x,NE_y and it gives these for each grid. I have a 3rd
table with geo coordinates. This tables gives Northings
and Eastings for each corner.
I want a query that will allow me to type in the grid B01
and show many a table with 16 results. It will show SW_x
and SW_y of the SW,SE,NW,NE corner. It will also give the
East and North of the SW,SE,NW,NE corner of that grid.
When I make a query and say to [Enter Grid_ID], I get 80
results instead of the desired 16.
If someone would like to help me, I can e-mail the tables
if that will help