Creating a column with the same info in each row?

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

Guest

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

cheers in advance.
 
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.
 
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.

djbiehl via AccessMonster.com said:
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.
Click to expand...
Click to expand...
 
Back
Top