[Solved] Report Format vs Query Format

Discuss the database features
Post Reply
chris_petersen
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

[Solved] Report Format vs Query Format

Post by chris_petersen »

Can someone please tell me why the report displays the date as some strange number format when the query displays the date properly? See examples below:

Also, Where are the actual database records stored? Are they in the odb file or in some other format in a seperate folder? I would like to move this database to another computer and would like to have all of the information.
Also, If I add changes to it here and take the odb to the other machine, I don't want to overwrite any records that they already have in place.

Thanks
Cap1.JPG
Cap2.JPG
Last edited by Hagar Delest on Fri Mar 31, 2017 8:59 pm, edited 1 time in total.
Reason: tagged [Solved].
Chris Petersen
Open Office 4.1.3
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Report Format vs Query Format

Post by charlie.it »

Ciao, the date format in the report is serial format. You can re-format it open the report in edit mode.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Report Format vs Query Format

Post by charlie.it »

The records are stored in .odb file. You can move the .odb file to another computer.
If you take the .odb file in another computer the operative system will ask to you if you want replace or keep both files.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
chris_petersen
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

Re: Report Format vs Query Format

Post by chris_petersen »

Thanks! That was easy. It's all fixed.
Chris Petersen
Open Office 4.1.3
Post Reply