Search results

Ranman256, thanks so much for your reply. I took your suggestion and did get it to work on a single polygon with multiple points. But I’m now stuck on how to get it to work with multiple polygons. The code below reads from a query that list the nodes for a single polygon. How would I go about...

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...

Fantastic!!!! Yes that did the trick. I just need to replace ; with , and worked just as you wrote it! Thanks so much JHB!!! You really made my day:)

Thanks for your suggestion moke123. I haven't written a function like this before. It might be a little over my head but I'll look into that. Thanks again

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...

CJ_London I'm just now able to get back to this project. Indeed there were dups in table_2 field "b" caused by another field, lets call it "e" that had multiple values for some items in "b". Once cleaned up there were no more dups. Thanks for pointing me in the right direction!

Hey CJ_London, I’m super embarrassed that I didn’t actually test the sample database above. And yes, it most certainly does work as you stated. But it’s not working on my real-life database. I’ve striped the two real-life tables down to KeyID and one text field each. The text fields are...

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...