Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how I can sum or subtract 2 or 3 field in access in any record
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how I can sum or subtract 2 or 3 field in access in any record
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 , "hadi" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
in vba for access how do i get the day of the week for a date field? | Excel Worksheet Functions | |||
Pivot Tables..I give up... | Excel Worksheet Functions |