Recent content by dance

Well, I pasted in my data to replace the dummy data provided and I think it hung. I don't know for sure because whilst I left it drawing and computing, the computer went to sleep. So I took out all but 10 of my test sites (but leaving the huge world data table intact) and tried again. This time...

Craig, I really appreciate this - whether it works or not! I'll test this asap and get back to you, if that's okay?

Yep, I would need the original point and the .5 N,S,E,W variations on it. I've had some really good advice elsewhere but I can't implement it because my Access skill level isn't good enough. Here, for example, someone pretty much hands it to me on a plate, but I can't work with it because I...

I need to return a report containing corresponding data for each of the c.100 sites in table one. Would you be willing to help me with that? If you are, contact me on access-programmers@trashmail.net and we can discuss recompense for your work.

bump? can anyone help? I don't think specific knowledge of lat longs is necessary if that's putting anyone off?

I would really appreciate some help with this: I have two database tables: -table one contains c.100 decimal lat/longs and a temperature. -table two contains lat/longs for the whole Earth (lots!) and a temperature for each coordinate. I want to query table one against table two and return a...