Search results
-
P
Referring to a range in access as in excel
Hi All, newbie question. I have two tables in Access 2016, one of points (x/y coordinates) and another of polygons (consisting of an Poly_ID and a series of x/y nodes defining each poly perimeter). I need to discover what points are in what polygon. The actual database has over 250K points and... -
P
Help getting a formula that works in Forms but not in a Query
Hi All, I been trying to figure out how to get a formula that works in Excel and Access Forms to work in an Access Query. I’ve attached a graphic showing what I’m able to do in Excel and also attached the sample access Db that shows it working in a Form. In short, I looking to get the average... -
P
Merging tables without adding new records
A little help please. In Access I have two tables (1 and 2), and the task is to insert tbl_2 into tbl_1. • No new records should be created in tbl_1. • tbl_1 and tbl_2 have a common field. • The number of fields in both tables are known and will not change. • tble_1 has fields that tbl_2 does...