How do I create a calculated field which displays a auto number ?

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

Hi,

How do I create a calculated field which displays an auto number ?
Thanks.
 
Adrian said:
Hi,

How do I create a calculated field which displays an auto number
? Thanks.
Click to expand...

You should be able to do it in a query eg:
"calkauto:[table.Autonumber]+56"

However, are you really sure you want to use an Autonumber in a
calculated field? The nature of Autonumbers make them unsuitable for most
uses other than as links and normally should not be visible to the user.
 
Thanks for the advice. I will reconsider...

--
Regards,
Adrian
Joseph Meehan said:
Adrian said:
Hi,

How do I create a calculated field which displays an auto number
? Thanks.
Click to expand...

You should be able to do it in a query eg:
"calkauto:[table.Autonumber]+56"

However, are you really sure you want to use an Autonumber in a
calculated field? The nature of Autonumbers make them unsuitable for most
uses other than as links and normally should not be visible to the user.
Click to expand...
 
You must log in or register to reply here.

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

MS Access problem 0
auto number in query 1
How do I calculate and store results? 5
Calculating averages on a form 3
Auto numbers 2
Last record plus 1 1
Auto number in an existing table 4
store a letter and leading zeros in an an access autonumber field 2

Back
Top