philipnet

I finally got to grips with JOIN last week!

Not that I've spent a long time trying, you understand - just that I needed to modify a report and that required me to delve into the depths of my SQL knowledge and to google and bit. I probably need to go over my SQL/database notes again!

But what gets me with Queries and Reports is the different table and field names! One can't cut-n-paste straight between the two. At the moment I'm resorting to modifying existing reports to do what I want. But I think it may be possible to convert the names - watch this space!