I have this query:
SELECT [Combined Currency Converted Budget and MHR Report].As_Of, [Combined Currency Converted Budget and MHR Report].[2008 Fiscal Year Activity], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Actual $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Budget MHR], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Actual MHR], [Combined Currency Converted Budget and MHR Report].[SumOfExpense Actual $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfExpense Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Labor Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Labor Actual $ Converted], [Process Proposals Budget and MHR Report].[Business Division], [Process Proposals Budget and MHR Report].[Cost Code FY 05], [Process Proposals Budget and MHR Report].[FY 05 BUnit], [Process Proposals Budget and MHR Report].CLIENT, [Process Proposals Budget and MHR Report].DESCRIPTION, [Process Proposals Budget and MHR Report].[PROPOSAL MANAGER], [Process Proposals Budget and MHR Report].[PROSPECT STATUS], [Process Proposals Budget and MHR Report].Proposal_Budget, [Process Proposals Budget and MHR Report].Scope, [Process Proposals Budget and MHR Report].Proposal_Office, [Process Proposals Budget and MHR Report].[Date WO Opened]
FROM [Process Proposals Budget and MHR Report] LEFT JOIN [Combined Currency Converted Budget and MHR Report] ON [Process Proposals Budget and MHR Report].[Cost Code FY 05] = [Combined Currency Converted Budget and MHR Report].[Proposal No]
WHERE ((([Combined Currency Converted Budget and MHR Report].[2008 Fiscal Year Activity]) Is Not Null) AND (([Process Proposals Budget and MHR Report].[Date WO Opened]) Is Null Or ([Process Proposals Budget and MHR Report].[Date WO Opened]) Between #9/1/2007# And #8/31/2008#));
That creates a report that if I select hide duplicates does exactly what I want it to do...EXCEPT it places blank spaces where the hidden records would be.
I need to either change this statement or figure out how to supress the blank spaces.
I have tried Select Distinct, the records are not true duplicates but they all have the same Cost Code number.
SELECT [Combined Currency Converted Budget and MHR Report].As_Of, [Combined Currency Converted Budget and MHR Report].[2008 Fiscal Year Activity], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Actual $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Budget MHR], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Actual MHR], [Combined Currency Converted Budget and MHR Report].[SumOfExpense Actual $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfExpense Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Labor Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Labor Actual $ Converted], [Process Proposals Budget and MHR Report].[Business Division], [Process Proposals Budget and MHR Report].[Cost Code FY 05], [Process Proposals Budget and MHR Report].[FY 05 BUnit], [Process Proposals Budget and MHR Report].CLIENT, [Process Proposals Budget and MHR Report].DESCRIPTION, [Process Proposals Budget and MHR Report].[PROPOSAL MANAGER], [Process Proposals Budget and MHR Report].[PROSPECT STATUS], [Process Proposals Budget and MHR Report].Proposal_Budget, [Process Proposals Budget and MHR Report].Scope, [Process Proposals Budget and MHR Report].Proposal_Office, [Process Proposals Budget and MHR Report].[Date WO Opened]
FROM [Process Proposals Budget and MHR Report] LEFT JOIN [Combined Currency Converted Budget and MHR Report] ON [Process Proposals Budget and MHR Report].[Cost Code FY 05] = [Combined Currency Converted Budget and MHR Report].[Proposal No]
WHERE ((([Combined Currency Converted Budget and MHR Report].[2008 Fiscal Year Activity]) Is Not Null) AND (([Process Proposals Budget and MHR Report].[Date WO Opened]) Is Null Or ([Process Proposals Budget and MHR Report].[Date WO Opened]) Between #9/1/2007# And #8/31/2008#));
That creates a report that if I select hide duplicates does exactly what I want it to do...EXCEPT it places blank spaces where the hidden records would be.
I need to either change this statement or figure out how to supress the blank spaces.
I have tried Select Distinct, the records are not true duplicates but they all have the same Cost Code number.
