CAN I USE AN EXCELL FORMULER IN ACCESS?

[mannir muhammad]

HELLO ONES AGAIN, PLS IN ACCESS, DOES IT ALLOWED TO USE EXCEL FORMULER IN IT??

 

[Joe4]

Please do not type in all caps. That is the internet equivalent of shouting (and usually is used to depict anger or outrage).

Access has many similar functions as Excel. What exactly is it that you are trying to do?
Can you post an example of a formula that you are trying to emulate?

 

[welshgasman]

I believe you can use Excel functions in Access, but you need to open a copy of Excel and refer to that object and function.

Google is your friend. That does not mind if you keep shouting all the time.

 

[mannir muhammad]

I believe you can use Excel functions in Access, but you need to open a copy of Excel and refer to that object and function.

Google is your friend. That does not mind if you keep shouting all the time.

OK thank you o much

 

[Micron]

Pretty sure you can use Excel formulas or functions in Access without opening an instance of Excel but you must create a reference to the Excel object library in your Access project. I have done so in the past, but it was on a limited basis.

 

[mannir muhammad]

Pretty sure you can use Excel formulas or functions in Access without opening an instance of Excel but you must create a reference to the Excel object library in your Access project. I have done so in the past, but it was on a limited basis.

thak you sir

 

[Micron]

To clarify, I meant you can use Excel functions/formulas in vba code - not directly in forms, reports or tables.