Compare Records & Move to new table in VBA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I want to make a loop whereby i can compare the first record with every other
record until i find a 'True' comparison, if i find this, move the records
into a new table, otherwise, move onto the second record and repeat.

I figured i would do this with a for next loop, i have done them in excel,
but im not certain of how to compare cells in access.

Thanks

Tom
.

Relevant Pages

  • Compare Records & Move to new table in VBA
    ... I want to make a loop whereby i can compare the first record with every other ... but im not certain of how to compare cells in access. ...
    (microsoft.public.access.macros)
  • =?Utf-8?Q?Re:_Referential_Integrity_=E2=80=93_Impo?= =?Utf-8?Q?rt_of_Data_from_a_purchased_p
    ... capture when someone has deleted part XYZ and someone else has added it ... compare all of the fields in the import data with all of the fields in the ... first record of the recordset to see if anything has changed. ... It appears that we are faced with importing this file on a daily basis into ...
    (microsoft.public.access.tablesdbdesign)
  • Open a table for search
    ... Using VBA I want to open a table. ... Then move to first record, ... data in and compare it to the data the user has typed into a ... Message “You’ve hit pay dirt” ...
    (microsoft.public.access.modulesdaovba)
  • Re: Selectedindices in Listview navigation..?
    ... You can compare ListView.FocusedItem.Index and ListView.Items.Count. ... current index is equal to (count-1), then not allow to go to next record. ... when they are in first record and trying to press ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Matching Data
    ... I have a query where company name fields from two different sources need to be compared. ... I need an expression that will compare the first 15 or so characters in each name and ones that do not match be returned. ... For the result I need the first record, where the names are not identical, to be returned and the 2nd two records to be ignored. ...
    (microsoft.public.access.queries)