[Solved] Report Format vs Query Format

Discuss the database features

[Solved] Report Format vs Query Format

Postby chris_petersen » Fri Mar 31, 2017 3:52 pm

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
chris_petersen
 
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

Re: Report Format vs Query Format

Postby charlie.it » Fri Mar 31, 2017 3:55 pm

Ciao, the date format in the report is serial format. You can re-format it open the report in edit mode.
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 6.2

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

Re: Report Format vs Query Format

Postby charlie.it » Fri Mar 31, 2017 4:02 pm

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
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 6.2

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

Re: Report Format vs Query Format

Postby chris_petersen » Fri Mar 31, 2017 7:48 pm

Thanks! That was easy. It's all fixed.
Chris Petersen
Open Office 4.1.3
chris_petersen
 
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests