Linking Access Query of Query to Excel - Blank Result

[nguyeda]

Hello,

In access I have a query (made from 2 queries) then compared against another double query.

When I open excel and try to import it (so they sync/refresh data). It just imports nothing but the headers, no data. Just 2 blank rows.

Anyone know why? My other imports to excel work just fine.

 

[nguyeda]

This is driving me insane.

I even consolidated the queries with more complex expressions. That's not the problem I don think.

 

[Rabbie]

If you posted the SQL of your queries we might be able to see why it is giving the results it is.

 

[nguyeda]

SELECT SWR.[Office], SWR.Product, [SOH C].SumOfUnrestricted, Sum(SWR.[Order Quantity]) AS [SumOfOrder Quantity1]
FROM [SOH C] RIGHT JOIN SWR ON [SOH C].[External Long Material Number]=SWR.Product
GROUP BY SWR.[Office], SWR.Product, [SOH C].SumOfUnrestricted
HAVING ((([SOH C].SumOfUnrestricted)>3) And ((Sum(SWR![Order Quantity])<[SOH C]!SumOfUnrestricted)=-1));

 

[nguyeda]

No ideas? Do I need to give more input?