How to set up relationship query for minerals database - continued

[Neville MADDEN]

:

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

èÙI
lt 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

 

[Jeanette Cunningham]

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