| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel Function to Access
I would like this excel function =IF(A4=A5,C5-C4,C5) to be utilized as
a function in a query in MS Access where the fields that supposed to be in column A are the primary key fields and the next fields which are in column C, are to be calculated in.The answers to this function are to go into a new field.....Any help please? :( |
|
#2
|
|||
|
|||
|
Primary key, by definition, means no duplicates. How would A4 ever equal A5?
-- George Nicholson Remove 'Junk' from return address. "CJT" wrote in message ... I would like this excel function =IF(A4=A5,C5-C4,C5) to be utilized as a function in a query in MS Access where the fields that supposed to be in column A are the primary key fields and the next fields which are in column C, are to be calculated in.The answers to this function are to go into a new field.....Any help please? :( |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
| Excel and Access talking | Excel Discussion (Misc queries) | |||
| Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
