Automatically fill table cell

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

Guest

I need a field for a zone - zone one is classes starting at 9 or 10 AM. zone 2 is classes starting at 11 or 12, etc, etc. Can a table have a field that will automatically fill in the correct zone based on the starting time field of that same table? All the data for that table except the zone field is imported from an excel spreadsheet.
 
after you do the import, you can run an update query on the table, using a
Switch() function (or call a public function using the Select Case
Statement, if you prefer to use VBA), as

Switch([StartingTimeFieldName] = "9 am", "Zone1", [StartingTimeFieldName] =
"10 am", "Zone 1", [StartingTimeFieldName] = "11 am", "Zone 2",
[StartingTimeFieldName] = "12 pm", "Zone 2")

set a criteria on the starting time field, as

Is Not Null

hth


Bogga said:
I need a field for a zone - zone one is classes starting at 9 or 10 AM.
Click to expand...
zone 2 is classes starting at 11 or 12, etc, etc. Can a table have a field
that will automatically fill in the correct zone based on the starting time
field of that same table? All the data for that table except the zone field
is imported from an excel spreadsheet.
 
Back
Top