2

I have a query in Access:

CREATE TABLE [t_Clusters_PassportsMicrofilm(fromDuplication)]    
(
[CLUSTER_ID] AUTOINCREMENT (92561,1),    
[NAME1_ID] TEXT(50),    
[NAME2_ID] TEXT(50),    
[NAME3_ID] TEXT(50),    
[NAME4_ID] TEXT(50),    
[NAME5_ID] TEXT(50))

but my infrastructure must be dynamic - "92561" as the argument value will probably change. I want to use an SQL statement instead of number for its value.

SQL statement like this:

MaxOfID_Research
FROM [t_Clusters_ResearchPassportsMicrofilms(afterDuplication)_union]

Does somebody know how I can make it work?

Inka
  • 21

0 Answers0