S
Science Lady
Hello and thanks up front... (I'm going bonkers),
It's invoice time, so in my "Job Records" file, I'm using a parameter query
(Excel 02, Microsoft Query) to return only those records that occur in one
specified month.
In the original Excel "Job Records" file on which the query is based, one
column of data, labeled "PO", lists purchase order names (e.g. "VBL" for a
verbal Purchase Order) or numbers (e.g. "102509"). The column is
automatically formatted by Excel as "General", and I just let it ride.
A second column of data, labeled "Funding Entity" lists codes - some codes
are letters , others are numbers, (e.g. "GF" for Gen. Fund, "21" for 21st
Fund) all formatted as "Text".
When I execute the query, everything works great (the correct records,
selected by month, are returned) except that the cells containing numbers
formatted as "General", when returned in the "PO" column, are skipped so the
resulting cell is just blank. And in the resulting "Funding Entity" column,
cells containing letters (e.g. "GF") end up blank and all those containing
numbers formatted as test, e.g. "21", show up just fine.
So, I end up with a "PO" column containing all the entries that were "VBL",
but only blanks where the entries that are numbers (formatted as "General")
should be and a "Funding Entity" column containing only "21", but no "GF"s.
I tried (feebly) to change the numbers formatting to "Numbers", but it
didn't work.
Anyone know where I went wrong?
It's invoice time, so in my "Job Records" file, I'm using a parameter query
(Excel 02, Microsoft Query) to return only those records that occur in one
specified month.
In the original Excel "Job Records" file on which the query is based, one
column of data, labeled "PO", lists purchase order names (e.g. "VBL" for a
verbal Purchase Order) or numbers (e.g. "102509"). The column is
automatically formatted by Excel as "General", and I just let it ride.
A second column of data, labeled "Funding Entity" lists codes - some codes
are letters , others are numbers, (e.g. "GF" for Gen. Fund, "21" for 21st
Fund) all formatted as "Text".
When I execute the query, everything works great (the correct records,
selected by month, are returned) except that the cells containing numbers
formatted as "General", when returned in the "PO" column, are skipped so the
resulting cell is just blank. And in the resulting "Funding Entity" column,
cells containing letters (e.g. "GF") end up blank and all those containing
numbers formatted as test, e.g. "21", show up just fine.
So, I end up with a "PO" column containing all the entries that were "VBL",
but only blanks where the entries that are numbers (formatted as "General")
should be and a "Funding Entity" column containing only "21", but no "GF"s.
I tried (feebly) to change the numbers formatting to "Numbers", but it
didn't work.
Anyone know where I went wrong?