By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,553 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Access - Sum of Null

P: 1

Hope some one is able to help

i have two tables. both tables contain a time column. and the time entered in these columns is specific to a number of people, all which will be entering in times. what i need to do is add these two times together so as to get a total for the people entering in the times. what i attempted was to create a query with the sums of these times, but say for example a person had entered into 1 table and not the other then he wouldnt show up in the summary at all.

i imagine this has to do with something like the nz function.

but im not sure where to put it and how, been trying everywhere. maybe im being stupid, but any help would be great

Apr 9 '08 #1
Share this Question
Share on Google+
1 Reply

P: 8
You might try a union query for the two tables and then summarize
Apr 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.