Expression builder help

[archy321]

Hello



I apologize in advance for the very noob question. I am trying to make a calculated field and having trouble coming up with a correct expression. Something like:
If ID isNOTnull then type location into into calculated field.

Any help is greatly appreciated!

V/R
Archy

[June7]

Sorry, don't understand. Cannot 'type' into a calculated field. It's a calculation.

[archy321]

I guess what i was looking for was for it to autofill with a specific text with each new record

[June7]

And where would that text come from? User input? Cannot do that with calculated field in table. And even if you do it in query, every record that meets the condition will show the same input.

[archy321]

Soo... kind of embarrassing... ends up i was trying to hammer a nail in with a sledgehammer last night. What i was trying to do was have two tables and have the fields automatically enter in their location depending on which table they entered the information in. All i really needed was to make a look up field with a default value of their location I.E. LA table automatically enters in LA and San Diego Table automatically enters in San Diego with each new record created. Thank you for taking the time to look into my question!

V/R
Archy

[June7]

If tables have location in their name, why would you need to bother with a field that has same value for every record?

Why do you even have separate tables? Do these tables have same structure? If so, sounds like should be one table with a field for location. Then having Location field makes sense.

[archy321]

There's a couple of reasons for the separate tables. There are coordinators at both locations and I wanted to make sure that they didn't accidentally input information for the opposing location. I also didn't want them to be over inundated with information that they didn't need to see as the tables in question are going to actually be SharePoint calendars. The higher ups can combine the calendars on their outlook calendars, but the two location coordinators will only have access to their own locations data. The higher-ups also want to see the schedules for both locations on one sheet, which required that I make a union query, but when I made a union query the differences between the two tables disappeared... I probably did something wrong, but I'm here now haha. The higher-ups also wanted the form to be in a specific layout...something like this...

LA first shift
San Diego first shift

LA second shift
San Diego second shift

Adding in the field allowed me to group the report to look like the above...so it would look something like

Group on caldate
Sort by shift
Sort by location

And with a little bit a tweaking I was able to get the report to look how they wanted it!

I hope I didn't do anything wrong and any suggestions would be greatly appreciated!