Exclusion

Jun 21, 2007

I have several tables with different infomation in them. When i join them in a crosstab query, it leaves out data that is not available in all fields. How can i get it to leave blanks in these spots and include the rest of the information.

i.e

Dept subaccount MTD YTD Prior YTD
1234 001 $500 $1000 $750
2345 002 235 750 900
3455 004 345 800

Currently my sheet would leave out the last line because there is not data for the prior information. I instead would like the information to appear just having a blank where there is missing data. Hope I am making sense! Thank you for your help!!

View Replies

Weekdays Exclusion

Jul 3, 2006

I m new 2 access, i have a query which i simply do not know how to handle. Please if anyone can help me:

I have a form having two dates on it, First is Invoice Date and the second is delivery date. What i wish to see is that automatically the invoice date takes date from system (this part is done), and the delivery date field automatically adds 2 more days to it and excludes weekend days, saturday and sunday. for example: a date of 6 July 2006 was picked by invoice date field from system, the delivery date now should add 2 more days to it plus it must not include weekend days in it, so the resulting date in delivery date field must read 10-Jul-2006.

Regards,

Darno

View 5 Replies

View Related