Quote Originally Posted by June7 View Post
Yes, can use functions with fields in query, example:

SELECT *, Val([fieldname]) AS FieldConverted FROM tablename;

However, Val() and all number conversion functions will error on Null.

What is adjNum? Why is it a text field? Why couldn't you change the field type, what happened?

Options may be:

1. nested SQL - Did you explore the link referenced in post 6?

2. separate query objects - do a query to get the max or min for the desired grouping then join that query to table or another query with the other fields (Hours and OTHours) you want

3. domain aggregate function
Thank you for your suggestions. I looked into the nested SQL post. I don't see how I can apply that in this case.

I don't see how I can use a domain aggregate function either.

Those Hours and OThours columns are throwing me off.