Compare fields

  • Thread starter Thread starter David F-B
  • Start date Start date
D

David F-B

Hi!

I really could do with some help comparing four fields in Access 2000.

I've got four fields I need to deal with:-

Title, Firstname, Surname, Contact

Contact is an amalgum of the first three.

So we get

Mr, John, Smith, Mr John Smith.

I currently type in everything myself. Inevitably with three thousand
records I have made errors. I would like to set up a query to check
if the first three fields put together equal the third. Trouble is, I
cannot put together the appropriate coding (i. e. I haven't a clue
what to do).

While I'm writing, is there a way of automatically producing the
Contact field from the other three fields? This would save time and
errors.

I need the first three fields for search purposes and also for other
unrelated queries. The last (contact) is typically used for mail
merges, etc.

Many thanks for all help given!

David F-B
 
David F-B said:
Hi!

I really could do with some help comparing four fields in Access 2000.

I've got four fields I need to deal with:-

Title, Firstname, Surname, Contact

Contact is an amalgum of the first three.

So we get

Mr, John, Smith, Mr John Smith.

I currently type in everything myself. Inevitably with three thousand
records I have made errors. I would like to set up a query to check
if the first three fields put together equal the third. Trouble is, I
cannot put together the appropriate coding (i. e. I haven't a clue
what to do).

While I'm writing, is there a way of automatically producing the
Contact field from the other three fields? This would save time and
errors.

I need the first three fields for search purposes and also for other
unrelated queries. The last (contact) is typically used for mail
merges, etc.

Many thanks for all help given!

David F-B
Click to expand...
Delete the contact field and use [Title] & " " & [Firstname] & " " &
[Surname]
where you would have used the [Contact] field.

It is generally not a good idea to duplicate data as this will often lead to
errors.

David
 
Hi!

I really could do with some help comparing four fields in Access 2000.

I've got four fields I need to deal with:-

Title, Firstname, Surname, Contact

Contact is an amalgum of the first three.

So we get

Mr, John, Smith, Mr John Smith.
Click to expand...

Well, here's a radical suggestion:

Remove the unnecessary, redundant Contact field from your table
altogether.

Instead, base all your Forms and Reports which need to show [Contact]
on a Query with

Contact: [Title] & " " & [Firstname] & " " & [Surname]

as a calculated field.
 
Eep! It is a bit radical. I have never done calculated fields
before. Will there be any problem with displaying the full name in a
form? What about when I want to do a mailmerge?

I'll have a scan through the help files and see what I can work out.
If I'm still stuck I'll get back to you all.

I guess that sorts out both queries.

Many thanks!
DF-B
 
Eep! It is a bit radical. I have never done calculated fields
before. Will there be any problem with displaying the full name in a
form? What about when I want to do a mailmerge?
Click to expand...

Simply base a textbox on the calculated field; and it's JUST as easy
to mailmerge from a Query as it is from a Table.
 
Back
Top