Rod-
Two solutions:
1) Create your table ahead of time and then use an INSERT query.
2) Assuming there's a copy of AuditorID in the company table (should be Long Integer), use that instead of the AuditorID AutoNumber from the auditor table.
If you're still stuck, post the SQL of your query.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 2, 2015, at 5:16 AM, desertscroller@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I am currently trying to create a table from a query but have an issue. The problem is the query is extracting data from two tables and data includes autonumber fields from the two tables. The table will not allow multiple autonumber fields. Both fields are needed but not sure how to approach the issue. I need to filter the new table on one of the two fields.
One field is the id of a company and the other is the id of an auditor. I am looking at creating a name from the auditor table then filter on it. Will take extra coding.
Anyone have another approach that would simplify the process?
Access 2010 , Windows 10, 8.1 and 7
Rod
One field is the id of a company and the other is the id of an auditor. I am looking at creating a name from the auditor table then filter on it. Will take extra coding.
Anyone have another approach that would simplify the process?
Access 2010 , Windows 10, 8.1 and 7
Rod
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar