All,
I'm very new to advanced Access queries and I'm trying to re-create the output from an Excel spreadsheet for a group. I've created two fields and would like to use those two field names to create a third in the same query. Is that possible? Here are the two fields I created.
Fall: IIf(DateSerial(Mid([WeekStartDate],7,2),Left([WeekStartDate],2),Mid([WeekStartDate],4,2)) Between #8/15/2014# And #12/1/2014#,[HOURS],0)
and
Spring: IIf(DateSerial(Mid([WeekStartDate],7,2),Left([WeekStartDate],2),Mid([WeekStartDate],4,2)) Between #1/10/2015# And #5/5/2015#,[HOURS],0)
Here's what I came up with in the interim:
Total Hours: IIf(DateSerial(Mid([WeekStartDate],7,2),Left([WeekStartDate],2),Mid([WeekStartDate],4,2)) Between #8/15/2014# And #12/1/2014# Or DateSerial(Mid([WeekStartDate],7,2),Left([WeekStartDate],2),Mid([WeekStartDate],4,2)) Between #1/10/2015# And #5/5/2015#,[HOURS],0)
I would rather have something like "Tot_hours: [Fall] + [Spring]". When I try this I get prompted for the value of "Fall".
Thanks in advance for any help.
Brian