473,326 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

convert excel formula to vba code access

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!
Jan 28 '20 #1
3 1757
twinnyfo
3,653 Expert Mod 2GB
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!
Jan 29 '20 #2
SioSio
272 256MB
Isn't it possible to achieve it with a query or with a combination of the Sum and IIF functions?
=Sum(IIF(.........))
Jan 30 '20 #3
twinnyfo
3,653 Expert Mod 2GB
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.
Jan 30 '20 #4

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

Similar topics

6
by: alphaomega3 | last post by:
I have a formula used in Excel that I am trying to convert for use in a query. the original formula is: ...
3
by: skiddle | last post by:
I've got an Excel formula that calculates the total business hours that a help desk ticket is open. As one would expect, it factors out holidays and non-work hours. What would be the corresponding...
1
by: yogeshbhardwaj | last post by:
I have an excel sheet. its format is like a group eport in access example given below: Soap Sr. no. Qty. Amount 1 15 150 2 ...
2
by: welshkaiboy | last post by:
Due to the size of the data I have to manipulate I need to apply a excel formula in access which determines date of manufacture from a serial number 716001 so I use...
2
by: rtilson | last post by:
I am not sure why excel and access use the same method in formula. I am not access expert but been trying to figure it out. Here is the excel formula that I would like to use in access expression...
0
by: Lina Arraiz | last post by:
I'm trying to export an Excel 2003 spreadsheet to Access 2007. I need to calculate the time elapsed between column D (START) and column E (END) with the results appearing in column F (TIME). The...
2
by: Geraldpauig | last post by:
Hi there, need help in converting the excel fomulas to ms access. =IF(C2<=0,IF(SUM(B$2:B3)<F$2,0,SUM(B:B)-F$2),"") below is the data from query1 and query2 QUERY1 COLUMN A ...
21
by: Sabrina Smith | last post by:
I am not a programmer - so I don't know code, however, I do need some help if anyone can oblige me... I have a project that requires me to add 4 workdays (excluding holidays) to a beginning date...
2
by: danifuture | last post by:
Hi All, I have a formula used in Excel that I am trying to convert for use in a query. the original formula is: =IF(D2>=45;IF((INT(B2/60)-1)<=0;0;INT(B2/60)-1);INT(B2/60)) Thank you.
2
by: Maran123 | last post by:
Hi, Please help to convert excel formula to MS access query =TEXT(D2-MOD(D2-2,7),"dd-mmm-YYYY")&" To "&TEXT(D2+7-WEEKDAY(D2,2),"dd-mmm-yyyy")
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.