Author Message

Dear Friends,

I am developing a GPS program that converts True bearings to Magnetic
bearings.  It does this by calling up information from an Access
database which stores the Chart information.  These being the Chart_ID
and Variation information in the format for example 12 degrees 00
minutes 1982 (10 minutes East) ------(1)  

 Now converting True to Magnetic bearings is simple. For eg:
True bearing is 0 - 359 degrees.
The Variation as determined from the Chart (as in access database) is 6
degrees West.

Rule is West (add)   and East (minus).

Hence True bearing is 60 degrees +  6 degrees = 66 degrees.  

The database consisting of 1 table needs to hold Variation information
and this is expressed in the format for example:  12 degrees 00 minutes
West 1982 (10 minutes East).  This means that in 1982 there were 12
degrees 0 minutes of westerly Variation but this was changing 10 minutes
East (ie reducing) every year.

Can anyone please tell me how I can represent the Variation in the
access database.  I have made an attempt to have Chart_ID, Variation (as
a decimal with +tve for West and - for East) and Base Year (date format)
- but htis is not sufficient since I need to be able to update the
database by entering data in the format  shown in ----(1).  This is
because once my database is complete then in my main form of my VB
application I will enter the Chart ID, True bearing and Current Year.
Then from the Variation information in the database I will be able to
calculate the True bearing for any Year.

Kind Regards,

Mon, 26 Aug 2002 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Questions, questions and more questions...

2. Update question and SQL question

3. dbComboBox question -- (question from a beginner)

4. Questions about refreshing datas (VB6+ADO+SQLSERVER2000) - please help (Newb question)

5. newB question: related tables question

6. Newbie question ( certainly stupid question)

7. text database question (rephrased from earlier question)

8. Drop Down List Question (And Tray Question)

9. QUESTION?: Swapping Table :QUESTION?

10. Oracle Forms question... Canvas questions

11. question I needd to do a restore with move for databases with filegroups - Synacx Question

12. QUESTION?: DB replication options :QUESTION?

Powered by phpBB® Forum Software