-
Editable Recordset
I would like to create a new recordset from a query and then be able to edit the values in added field as if it were a new temporary table without changing the original tables. The purpose is to be able to do a calculation on the recordset only to determine the order to display them. I tried making the query adding '0 as sortorder' so I have a field to put the result into but the recordset is uneditable. I understand why but I don't know how to do this properly.
-
Can't you do the "calculation on the recordset only to determine the order to display" in the query?
Please provide more detail.
-
I'm loading addresses to accounts and calculating distances between them using online sources then sorting them from closest to farthest using the value in the field with the results.
-
I guess that when your are able to do the calculation on the recordset, you can also make a function to do the calculation. Hence you can use the function in the query.
-
just add another Field (Distance, double) to your table then add the field to your query.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules