How to add a blank column as text, number or currency

  • Thread starter Thread starter jennifer
  • Start date Start date
J

jennifer

I need to create empty fields to use as placeholders for future data input.
I know how to create a blank text field by doing this: fieldname:"". Is
there an equivalent expression to create a blank numeric or currency
formatted field?
 
I need to create empty fields to use as placeholders for future data input.
I know how to create a blank text field by doing this: fieldname:"". Is
there an equivalent expression to create a blank numeric or currency
formatted field?
Click to expand...

Putting a zero length string in a Query as you describe will NOT create a
placeholder for future data input. A Query is just a view of the data in your
table. If you want to store data (now or in the future) you must create a
field in the table for that purpose! The simplest way to do so is just in
table design view, which will let you specify the datatype and size of the
field.
 
Back
Top