Help with make-table query, add a numbered field

[AlGreko]

Hi, I was wondering if someone could provide some help.

I have a make-table query based on fields from another query. I would also like this new table to include a new number field which starts at 101 and counts up for each entry.

So currently looks like this:
Name1, Name2, Name3
A, B, C
D, E, F
G, H, I

and I would like this:
Num, Name1, Name2, Name3
101, A, B, C
102, D, E, F
103, G, H, I

Hope that makes sense! Any help would be great.
Thanks

 

[jdraw]

Why are there 3 name fields in a record?
What is the purpose of the number?

Perhaps there are options if we knew more about your situation.

 

[AlGreko]

Thanks for the reply. Sorry if it was not clear, that was just an example, they are not actually called Name1, Name2 etc. There are several fields with text and numbers, all with different titles.

I would like to make several tables from several different queries, and eventually join these together. I want to use 101, 102, 103... for the first table, then 201, 202, 203... for the next and so on, so I can keep things ordered for future analysis.

 

[Mihail]

Pseudocode:
Num: DCount(PreviousRecords)+101

 

[Mihail]

Thanks for the reply. Sorry if it was not clear, that was just an example, they are not actually called Name1, Name2 etc. There are several fields with text and numbers, all with different titles.

I would like to make several tables from several different queries, and eventually join these together. I want to use 101, 102, 103... for the first table, then 201, 202, 203... for the next and so on, so I can keep things ordered for future analysis.

Seems that you try to treat Access DB as a Excel workbook and the tables as sheets.
If you need a DB then forget Excel.
And read this: Database Normalization and Table Structures - Microsoft Access / VBA

 

[AlGreko]

Thanks for the reply Mihail, but could you tell me where/how to use that expression in the query design, I pasted it in but it says the expression has the wrong number of arguments.

I'm new to this