Update a field with the active table name

[rockell333]

I want to place the table name formatted as a date in a field in that table. Meaning:



Table name is 082615
Field in Table File_Date
All records in thta File_Date column should read 8/26/2015

[ranman256]

do you mean create a table?
run a make table query.
or make the table in design mode.

[rockell333]

no... I want to populate a field within a table with that table name NOTE: its a Date field

[June7]

Why do you have tables that have dates as names?

Can run and UPDATE sql action.

[rockell333]

what would the update say.. to set as the table name

[rockell333]

The files are daily so they are named as such. 091815 and so on.. the field doesnt necessarily have to update as a date field but i need to identify the date in the table, as the table eventually gets renamed

[orange]

rockell333,

Step back and tell us in plain English what you are trying to do. No jargon--just simple English.
Your posts are not making much sense in terms of well designed relational database.

[rockell333]

i did earlier in the string. very simply i want to update a field with the table name

[June7]

So you are creating a new table every day? This is bad design. Records should be imported to existing table.

If the field is a text then the parameter needs apostrophe delimiters, if it is a date/time then # delimiters, number don't have delmiters.

UPDATE tablename SET fieldname = 'SomeValueHere'

UPDATE tablename SET fieldname = #SomeValueHere#

UPDATE tablename SET fieldname = SomeValueHere

How you get data into SomeValueHere can be done many ways.