If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
using excel syntax as queries in ms access
is it possible to use excel syntax for formulas as queries in ms access?
also, is it possible that for two tables that has a common field, once you enter new record in one table, same is also recorded in the child table?i'm lost...help! abel |
#2
|
|||
|
|||
using excel syntax as queries in ms access
Some Excel formulae will transfer directly to Access, some won't.
For example Excel uses If() and Access use IIf(). Try using the excel function and if it doesn't work find the Access function that does. Don't save the same data, other than key fields (the relationship), in two tables that are related. The advantage of a relational db like Access as opposed to a flat db like Excel is that you don't need to store redundant data. Also, you don't want to enter data directly into a table. Use forms. In a form you can enter data in the Parent table and the Child table via a subform. When the primary key data is filled in for the Parent the foreign key data is filled in automatically when data is added to the subform. Abel wrote: is it possible to use excel syntax for formulas as queries in ms access? also, is it possible that for two tables that has a common field, once you enter new record in one table, same is also recorded in the child table?i'm lost...help! abel -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200606/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trouble with randomizing getting to Excel | BnB | Running & Setting Up Queries | 3 | December 30th, 2005 12:55 PM |
Can access calculate balances like excel? | Carmen | New Users | 10 | October 19th, 2005 09:05 AM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
Using Excel charts in Access 2003??? | PZStraube | General Discussion | 0 | March 1st, 2005 01:02 PM |
Bitwise And | Sam Hobbs | Running & Setting Up Queries | 44 | October 14th, 2004 04:19 AM |