This is a simple solution but having some difficulty getting it to execute. I have 2 tables that I need to build a relationship between. The 2 fields I wish to use to tie them together have the exact format but the content varies slightly. Table One/field One is ###########.0 and table two/Field one is ###########.1. All the #####s match up just fine. I need to edit the first one so that it ends with a 1 in the last space.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query to Report
- Thread starter agape234
- Start date
This is a reports forum and you do mention the word "report" in the subject. However, you seem to be asking how to create an update query to change the values in a field. What's up?
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question