Recent content by dallascowboys

You are right on the data file being consistent. The issue is that file we receive is from the State Level so we have no say so on the / or - .

What do you mean, Can you show me an example

TRANSFORM Count(tblReimb.Row) AS CountOfRow SELECT tblReimb.FY, Left([FY-Qtr_str],2) & "/" & Mid([FY-Qtr_str],3,2) & "-" & Right([FY-Qtr_str],1) AS [FY-Q], Count(tblReimb.Row) AS [Total Of Row] FROM tblReimb GROUP BY tblReimb.FY, Left([FY-Qtr_str],2) & "/" & Mid([FY-Qtr_str],3,2) & "-" &...

Hello, What is the SQL Statement if a field changes for example changes from 20/21 to 21-22 and you want another to populate with the change for example 21-22-1