How to set up relationship query for minerals database - continued

  • Thread starter Thread starter Neville MADDEN
  • Start date Start date
N

Neville MADDEN

:

Thanks to everyone who replied to my previous questions with suggestions.

èÙIlt that the easiest solution was to be able to open another query and type
in the indivdual minerals found at that specific location and if there were
three minerals (eg cassiterite, shceelite and sapphire) I would then have
three reports, one for each mineral.

Next minor problem that someone may be able to help me is that the table with
mineral properties uses the European style notation for numbers for Specific
Gravity e.g. 3,2.

Any suggestions how I can convert this to 3.2

There are about 4000 records in the properties table.

I have messed with different types of queries using wildcard but no success.
One of the problems is that specific gravities range from 1,00 to 22,7 in the
table. (Would have been great if they had leading zeros before the numbers
1-9,99).

Thanks


Neville
Cootamundra
Australia
 
Hi Neville,
check out the Replace function ( which I think is in A2000 and above).
Make sure to back up your table first, try a test run on some dummy data to
make sure it works the way you want. You would use the Replace function in
an update query for the field that has the data with European separators.

Jeanette Cunningham
 
Back
Top