Creating a column with the same info in each row?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadiver - 26 Jul 2006 16:58 GMT

Is it possible to insert an expression that creates a column to produce the
same information for each row?

cheers in advance.

Reply to this Message

djbiehl - 26 Jul 2006 18:35 GMT

Yup. Do this:

Open your query in design view

In a blank column, add the following to the "Field" row:
alias: [fieldName]
Where alias is the name of the new column you would like created, and
fieldName is the name of the field from the table you would like the
duplicate row.
Next select the Table where that field resides and it should work. You can do
that as many times as you want as long as the alias' are unique.

>Is it possible to insert an expression that creates a column to produce the
>same information for each row?
>
>cheers in advance.

Reply to this Message

scubadiver - 27 Jul 2006 08:28 GMT

The information I would like to create I don't have in any of my tables, so I
presume it cant be done.

I have managed to create a parameter, type text in the text box and it will
create a new column with the text in every row but that is too complicated.

I think I will have to create some new fields and do an update query.

> Yup. Do this:
>
[quoted text clipped - 12 lines]
> >
> >cheers in advance.

Reply to this Message