Background -
I have app for managing cattle (UK)

If a calf is an Embryo transfer then [Dam ID] and [surrdamID] will be
different.
If the calf is natural then the 2 field will contain the same number (
Historic Issue involving 10 years ao data!)

A query sorts out data which is used to generate an email to send new calf
details to the gov database.

Up to now I have been registering ET calves manually but I am trying to
tweak things to solve this.

The simple answer would be to get the query to do this > If dam ID =
SurrdamID then surrdamID is Null

Can not figure out how to sort this

TIA
David

Do you want to do this permanently, or just for a form or report?

If permanently, use an Update query:

UPDATE MyTable
SET surrdamID = Null
WHERE [Dam ID] = surrdamID

If just for a form or report, use a query that has the a calculated field
along the lines of

IIf([Dam ID] = [surrdamID], Null, [surrdamID])


"David B" wrote in message news:LNadnd_Ge98x25bSnZ2dnUVZ8gOdnZ2d (AT) bt (DOT) com...

Background -
I have app for managing cattle (UK)

If a calf is an Embryo transfer then [Dam ID] and [surrdamID] will be
different.
If the calf is natural then the 2 field will contain the same number (
Historic Issue involving 10 years ao data!)

A query sorts out data which is used to generate an email to send new calf
details to the gov database.

Up to now I have been registering ET calves manually but I am trying to
tweak things to solve this.

The simple answer would be to get the query to do this > If dam ID =
SurrdamID then surrdamID is Null

Can not figure out how to sort this

TIA
David

Spot on. Many thanks

DB

"Douglas J Steele" <NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote