Search results

I have a Table consisting of Marriages - Surname & Firstname of Groom & Surname & Firstname of Bride - The table has many duplicates - I need to remove Excess Grooms that have the same names & are married to the same person & leave any that have the same name But are married to a different...

Hi All I have a Main Form, This Main Form has a Subform, the SourceObject for the subform is another form. What I am trying to do is to set the RecordSource for the SourceObject Form from within the code behind the main form so i can use the same form with various queries. Appreciate any help -...

Hi I'm trying to find a way to query a field in a table & find any numbers that are not in numerical order & also the record number of the out of place number Thanks

Whoops! Forgot the punchline.... The names would not be in the same record as each other - they could be anywhere in the table so would have to find them first before matching them. Also to make sure I had the correct match, i would probably have to match the Father/Husband as well - is this...

Hi All I Have a table which contains two fields with a person's Surname & initial(s) as someone's Spouse, and another two which contain the same person's Surname & Firstname as a Parent - the first name field has their full first name in this case. What i am trying to do is compare the surname...

Thanks - I modified the query to Is Null & it found the records I needed to find. The funny thing was that if you used Find/Replace on the table & searched For Not Stated it found them!! but the query would not.

I am using @;"Not Stated" in the format property of each field of a table so that Not Stated goes into the field if there is no other data entered from a form. The problem is that I need to delete records if certain fields contain Not Stated - I have tried a delete query, but it doesn't find...

I am using @;"Not Stated" in the format property of each field of a table so that Not Stated goes into the field if there is no other data entered from a form. The problem is that I need to delete records if certain fields contain Not Stated - I have tried a delete query, but it doesn't find the...