Base: Data modification queries? append, update?
Posted: Wed Jun 11, 2008 2:07 am
I'm a new user of OpenOffice Base, but I have quite a bit (too much??) familiarity with other dialects of SQL. My current problem is that I'm trying to massage a non-normalized spreadsheet type of list (newspaper subscribers and subscription renewals to be exact) into normalized tables.
In Access or SQL/Server I'd do this by creating Group By queries or DISTINCT queries, and changing them into a MakeTable or Append query. I am sure there is a way to do this in OOBase, but I haven't found it! Any suggestions?
I'm running a freshly installed instance of OO 2.4.1 on WindowsXP.
I'm looking forward to participating in this group; as I get more familiarity with the way things are done in this programming environment, I hope I'll be able to help others.
John W. Vinson aka John the Wysard (no false modesty there!)
In Access or SQL/Server I'd do this by creating Group By queries or DISTINCT queries, and changing them into a MakeTable or Append query. I am sure there is a way to do this in OOBase, but I haven't found it! Any suggestions?
I'm running a freshly installed instance of OO 2.4.1 on WindowsXP.
I'm looking forward to participating in this group; as I get more familiarity with the way things are done in this programming environment, I hope I'll be able to help others.
John W. Vinson aka John the Wysard (no false modesty there!)