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

Subtotals in Access Query

P: 4
Am trying to create SQL to subtotal by each ILDOC number. The transaction amount,field ILPAID. Both fields are type "number". I am basically just starting to trying to write formula. Thanks, John
Jan 26 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,308
Queries are not generally where you'd manage subtotalling John. Queries produce raw data for you. Reports and forms are where you display and maybe even manipulate the data.

It's not absolutely impossible, using DSum() etc, but it's almost always a very bad idea. Performance is badly impacted and maintenance becomes a mess. My advice, don't do it that way. Do it properly. Do it where it makes sense to.
Jan 27 '18 #2

Post your reply

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