Pre text ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Painter666 - 16 Apr 2005 12:00 GMT

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 :-)

Reply to this Message

Tim Ferguson - 16 Apr 2005 19:33 GMT

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

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.

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

Reply to this Message