I have a table that has 3 columns. One is Name. Another is Code Name. And the 3rd is Hours.
Using an test employee named "John Doe" I am trying to sum the hours in the table for him where the Code name started with "SN-2".
So if for example there were 3 records and one of them had a code name entered that was SN-2 Apple that had 1.5 hours, another that was SN-2 Peaches that had 4.3 hours, and a third record that had "SN-2 Pears" that had 5.2 hours I want to see 8.2 hours for the total.
I've tried this in the query designer but am not getting the correct result:
SN-2 Hours: Sum([Hours (Hours)] Like [Code Name]="SN-2" & "*")
Can someone help?