Count Records In Make Table Query?

L

Ladybird

How is an Incremental Number or a Count records assigned to a field when
using a
Make Table query?
 
D

Dan Artuso

Hi,
Does this help? Autoincrement is your incremental field:

CREATE TABLE Code3 (
ID AUTOINCREMENT,
Account TEXT(50),
Code MEMO,
Active Bit,
Hits int,
Rotation int
)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Count and assign 2
Make table query: [Enter 1] AS Test 1
Help with a query 3
Dcount returning no results!!! 0
Make Table AutoNumber? 3
Make-table query with around 2 ml records taking too long 0
Need help with Update query 4

Top