Selected data for Report

[Allilue]

Here is some background info before I ask my question:

tables: name, various other fields
forms: to add new names to these tables

The forms are there to add a new name to tables that hold information about this person. However, when a new name is added, it is not a brand new name, but an update to an existing name. therefore, the table may contain the name "joe", and add a new name called "new joe" to differentiate from the original.

Now, i want to create a form that compares some data based on these names. for example, if there is a field "age" for each name, and if i wanted to calculate the average "age", i want the report to pick up all names, except for the original. this would allow me to calculate the average age, based on the new record for the individual.

i hope this is clear (?) if this is possible, please let me know... i'm thinking that it may be possible, if the original name and the new name are identical, except that the new one actually has the word "New" in front of it.

Thanks!

 

[Jn88]

If it is a lot of names than add a new field with the type of “Yes/No” and thane Wright code that runs through each record and test with the “Instr” function if there is the word new in the name field and if yes it should check the “New” field and then in report query filter only where the “New” field is checked.

Jn88

 

[Allilue]

But would this pick up all original names, and only the new name for one of them? if these are the names:
"A","B","C","D","E","F","G"
and there is "New B" added,
then I want to calculate for "A", "New B", "C", "D" etc., and leave out the original "B" only, would that work?

 

[Jn88]

No, it won’t work. But there can be 100 solution’s for this but I don’t know your exact problem.

Jn88