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

convert excel formula to vba code access

P: 1
Hi there, need help in converting the excel fomulas to ms access.
Expand|Select|Wrap|Line Numbers
  1. =SUMIFS($W$2:$W$50000,$M$2:$M$50000,"<"&$M2,$A$2:$A$50000,$A2)
please advise.. many thanks!
3 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,364
skam75,

Welcome to Bytes!

What you are asking is not answerable. Excel is a spreadsheet and the formulas are designed for spreadsheets. MS Access is a database with tables with fields and records. Trying to convert a formula directly from Excel into Access doesn't work that way. You would most likely need to create a query on your Access table, but, not knowing anything about your database, we can't advise you much further here.

Hope this hepps!
3 Weeks Ago #2

P: 94
Isn't it possible to achieve it with a query or with a combination of the Sum and IIF functions?
=Sum(IIF(.........))
3 Weeks Ago #3

twinnyfo
Expert Mod 2.5K+
P: 3,364
SioSio,

Yes, it might be possible to do that, but it depends on whether OP is talking about a calculated field in a table, just displaying it in a query or summing values on a report or form. Since there are too many unknowns at this point, it's difficult to advise further, other than to ask for more details, which we have yet to receive.
3 Weeks Ago #4

Post your reply

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