[libreoffice-users] [Base} Compare contents of similar records on two sheets

2012-04-12 Thread Preston Smith
Hello, I have asked this question previously in the context of two spreadsheets. I know now that I can migrate my spreadsheets to BASE and with minimal fuss make it work for me. I have two sets of records. My Master database and a monthly update that reflects additions, deletions and

Re: [libreoffice-users] [Base} Compare contents of similar records on two sheets

2012-04-12 Thread Mark Stanton
Both of these will be easy to do as a query in Base, although the first is a little tedious, provided that you can get both tables into the same database. Something along the lines of SELECT * FROM MasterTable JOIN MonthlyUpdateTable ON Master.IdField = Month.IdField WHERE