Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

how I can sum or subtract 2 or 3 field in access in any record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hadi - 04 Nov 2006 23:04 GMT
hi
I want know that why there is NOT any relationship   between access and excel
and how I can sum and subtract 2 or 3 filds in access in any record
thanks
hadi_khodaparast@yahoo.com
CyberTaz - 04 Nov 2006 23:27 GMT
Hello Hadi -

I'm not sure I understand exactly what you are asking, but Excel is *not* a
'front end' for an Access database. You can use Excel to query the db & copy
Access data into a workbook in several ways. That copy of the data can be
used for calculations, but the data *doesn't* get changed in the Access
file. Although the modified results can be imported to Access it may very
well be the long way around.

Why not just create the calculation as a part of an Access Query, Form or
Report? Especially if you're not looking to do anything more complex than
simple addition & subtraction there's nor reason to go outside the db.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 11/4/06 5:04 PM, in article
1B1925E7-2E6B-497D-AA3D-44EA5A9DC6B7@microsoft.com, "hadi"

> hi
> I want know that why there is NOT any relationship   between access and excel
> and how I can sum and subtract 2 or 3 filds in access in any record
> thanks
> hadi_khodaparast@yahoo.com

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.