ACCESS FEED: Re: [MS_AccessPros] Create table from query issue

Kamis, 03 September 2015

Re: [MS_AccessPros] Create table from query issue

Hi Rod,

wrap your autonumber fields with cLng in the query and assign a new name

MyNewfieldname: cLng([AutonumberFieldname])

warm regards,
crystal

2015 Microsoft MVP Virtual Conference Presentation on Access Web Apps, and linking to SQL Azure from Access, Excel, and SSMS (53 minutes)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

~ have an awesome day ~

On 9/2/2015 2:44 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

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

http://www.viescas.com/

(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