Sfrgttk

Why doesn't a const reference extend the life of a temporary object passed via a function?

Could Giant Ground Sloths have been a Good Pack Animal for the Ancient Mayans

How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?

What are the advantages and disadvantages of running one shots compared to campaigns?

"listening to me about as much as you're listening to this pole here"

Is a car considered movable or immovable property?

Lied on resume at previous job

What happens when a metallic dragon and a chromatic dragon mate?

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

How to deal with fear of taking dependencies

Are white and non-white police officers equally likely to kill black suspects?

How would photo IDs work for shapeshifters?

Symmetry in quantum mechanics

Why is the design of haulage companies so “special”?

How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)

Check if two datetimes are between two others

When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?

Why is my log file so massive? 22gb. I am running log backups

Eliminate empty elements from a list with a specific pattern

I see my dog run

I am not able to install anything in ubuntu

Does a dangling wire really electrocute me if I'm standing in water?

Email Account under attack (really) - anything I can do?

Calculate Levenshtein distance between two strings in Python

Access query to locate changed records

MS-Access vba sql update where not workingI am Trying to Write an Access Query to Get a person having a First Name and Last Name but not all People having any of those namesHow to define destination for an append query Microsoft AccessFinding the names and the year of the movies that have at least 5 actorsWhy would suser_name() not reflect an AD account name change?Access 2010 Need help connecting/updating database dataHow to simplify this query?Make custom query from two table accessSave Access SQL code to text file or Python variable?Unique Records property in Delete Query

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I have a database of specimens for a natural history collection. The scientific names for the specimens have changed since the last name update ~10 years ago. The actual specimen entries are recored in a catalog that references unique IDs in Names to show the identification. I updated the names and IDs (which are formulated from the names) in Microsoft Access and I now have three spreadsheets: Names, OldNames, and Catalog.

[Names] structure

    AllID NewID Name



[OldNames] structure

    ID Name



[Catalog] structure

    ID (could be an AllID or NewID) Specimen#

Now I need to find all the names that changed between AllID and NewID, locate the corresponding specimen by number, and physically change the label. My current code is to run a query with [Names].[AllID] linked to [OldNames].[ID] and [Catalog].[ID].

Field: AllID

Table: Names

Criteria: Not[Names].[NewID]

I also attached [Catalog].[Specimen#] so that I can locate the actual specimen.

The problem is that the query does not retrieve all of the changed fields. I noticed this because a physical specimen with an old ID was not on the list created by the query. Should line of code

Criteria: Not [names].[NewID]

return all IDs that were updated? If not, what other code should I use?

All help is appreciated, including a link to the same question asked by another user. This seems quite simple and basic but I'm unable to find an answer so far.

ms-access

share

asked 5 mins ago

RoseRose

1

New contributor

Rose is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have a database of specimens for a natural history collection. The scientific names for the specimens have changed since the last name update ~10 years ago. The actual specimen entries are recored in a catalog that references unique IDs in Names to show the identification. I updated the names and IDs (which are formulated from the names) in Microsoft Access and I now have three spreadsheets: Names, OldNames, and Catalog.

[Names] structure

    AllID NewID Name



[OldNames] structure

    ID Name



[Catalog] structure

    ID (could be an AllID or NewID) Specimen#

Now I need to find all the names that changed between AllID and NewID, locate the corresponding specimen by number, and physically change the label. My current code is to run a query with [Names].[AllID] linked to [OldNames].[ID] and [Catalog].[ID].

Field: AllID

Table: Names

Criteria: Not[Names].[NewID]

I also attached [Catalog].[Specimen#] so that I can locate the actual specimen.

The problem is that the query does not retrieve all of the changed fields. I noticed this because a physical specimen with an old ID was not on the list created by the query. Should line of code

Criteria: Not [names].[NewID]

return all IDs that were updated? If not, what other code should I use?

All help is appreciated, including a link to the same question asked by another user. This seems quite simple and basic but I'm unable to find an answer so far.

ms-access

share

asked 5 mins ago

RoseRose

1

New contributor

Rose is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a database of specimens for a natural history collection. The scientific names for the specimens have changed since the last name update ~10 years ago. The actual specimen entries are recored in a catalog that references unique IDs in Names to show the identification. I updated the names and IDs (which are formulated from the names) in Microsoft Access and I now have three spreadsheets: Names, OldNames, and Catalog.

[Names] structure

    AllID NewID Name



[OldNames] structure

    ID Name



[Catalog] structure

    ID (could be an AllID or NewID) Specimen#

Now I need to find all the names that changed between AllID and NewID, locate the corresponding specimen by number, and physically change the label. My current code is to run a query with [Names].[AllID] linked to [OldNames].[ID] and [Catalog].[ID].

Field: AllID

Table: Names

Criteria: Not[Names].[NewID]

I also attached [Catalog].[Specimen#] so that I can locate the actual specimen.

The problem is that the query does not retrieve all of the changed fields. I noticed this because a physical specimen with an old ID was not on the list created by the query. Should line of code

Criteria: Not [names].[NewID]

return all IDs that were updated? If not, what other code should I use?

All help is appreciated, including a link to the same question asked by another user. This seems quite simple and basic but I'm unable to find an answer so far.

ms-access

share

asked 5 mins ago

RoseRose

1

New contributor

Rose is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

[Names] structure

    AllID NewID Name



[OldNames] structure

    ID Name



[Catalog] structure

    ID (could be an AllID or NewID) Specimen#

Field: AllID

Table: Names

Criteria: Not[Names].[NewID]

Criteria: Not [names].[NewID]

share

asked 5 mins ago

RoseRose

1

New contributor

Rose is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

RoseRose

1

New contributor

Rose is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

RoseRose

1

New contributor

Rose is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

RoseRose

1