Pre text ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to set a field in a table to put a predetermined letter or number in
a cell.

Where I would usually have it autonumber a list I need to put P1,P2,P3 etc.
instead of 1,2,3.
I know I need to use "text" as the data type but is there a way to get it
automatically put the "P" in the cell so I only need to input the number ?
Or is there a way to autonumber with the letter ?

There are another few instances where this would be helpful but this is the
most simple example I can think of.

Thanks for any help :-)
 
I want to set a field in a table to put a predetermined letter or
number in a cell.
Click to expand...

Big warning here: spreadsheets have cells, while databases have tables, columns and
records. Spreadsheets do what they do very well, but databases do spreadsheets vry
poorly.
Where I would usually have it autonumber a list I need to put P1,P2,P3
etc. instead of 1,2,3.
Click to expand...

You put it in the query:

SELECT "P" & MyNumber AS MyFormattedNumber
FROM MyTable
etc..

If the "P" is going to vary, and if it has some meaning, then you need another column
in the table; but that is a slightly longer answer.

Hope that helps


Tim F
 
Back
Top