Subject: How to set up relationship query for minerals database - continued

[Neville MADDEN]

:

Thanks to everyone who repliedto my previous questions with suggestions.

I felt 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

 

[John Spencer]

What is the field type of Specific Gravity field. If it is a text field you
can use the Replace function to update the comma to a period.

REPLACE ([Specific Gravity],",",".")

You can use that expression as a calculated field in a query
or
You can use an update query an update the Specific Gravity field to the
expression.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..