-
show zero amount in pass thru query
Hello,
I am using MS Access 2010 I have a pass thru query getting data from db2 no issues here, my problem is if the results are zero I want to show the month field (SHSHPM) = 4 and the year (SHSHPY) = 2014 and the COST field would equal zero amount. If I ran the pass thru I get nothing, which is correct. Does anyone know how I can do that? Thank you in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|