RMA26

I need help with above, anyone?

PeteBrant

Can you be a bit more specific?

bob269

Press F1 or tell us what you want it to do

RMA26

I have a sheet full of data, I use MS Query to extract the data i need (via a validation cell)

I then use this query & combine various countif's etc for my data colation & charts



Column E - Dates are not being displayed in the SQL Query, nor the networkdays

I have redone the query to no avail

I am stuck!

Thanks

RMA26

This is the generated SQL

SELECT `Jan$`.ClientID, `Jan$`.IntroducerID, `Jan$`.MatterID, `Jan$`.StartDate, `Jan$`.AbortDate, `Jan$`.AuthActDate, `Jan$`.`Authact Received`, `Jan$`.Client, `Jan$`.Networkdays, `Jan$`.Introducer
FROM `P:\MI & Analysis\Abort - Jan`.`Jan$` `Jan$`
WHERE (`Jan$`.Introducer Like ?)
ORDER BY `Jan$`.StartDate