Hello,
I am trying to create a query with client's first and last name, their addresses, city, home phone, and cell phone and 1st date of service. I want the query to only show unduplicated clients; 'First Name' and 'Last Name'; based on their 1st date of service for the current fiscal year July-June.
I also need to have total services for each client calculated... 'Total Trips'
Transportation Field: Total Trips
I will be exporting this info to an excel spreadsheet that will populate that information as it is changed.
-Kim
I am trying to create a query with client's first and last name, their addresses, city, home phone, and cell phone and 1st date of service. I want the query to only show unduplicated clients; 'First Name' and 'Last Name'; based on their 1st date of service for the current fiscal year July-June.
I also need to have total services for each client calculated... 'Total Trips'
Transportation Field: Total Trips
I will be exporting this info to an excel spreadsheet that will populate that information as it is changed.
-Kim
Last edited: