Help me create my First Tables and Relationship in Access

Myproblem

Board Regular
Joined
May 24, 2010
Messages
198
i am preety new in Access but and i have some task to do which is preety simple, but hard to me - to create simple table

here is the problem
I have to create table with some fields for each month: Account (Text is format, but it is acctually number), Account_Name (Text), Amount (Number), Date (Date). I know how to create this table.
Account in this table is unique.

I have to create an another table with fields: IFRS (text is format, but it is acctually number), IFRS_Name, and all the fields same as in first table [Account (Text is format, but it is acctually number), Account_Name (Text), Amount (Number), Date (Date)]. IFRS and IFRS_Name are unique in this table.

What I need is to put,make relationship in the way that Data field Account belonge to field IFRS from first table.

My task is very simple: to make query in the way in which you can make querry for certain date, or dates for IFRS.

I am loosing my mind making two different tables and trying to make adequate relationship, but i get error messages.

thx
 

Myproblem

Board Regular
Joined
May 24, 2010
Messages
198
i think the problem is with Join Properties. I do not know how to assign certain Account in Account table to Account in IFRS table.

and after that make query bassed on IFRS and Account table, but with data from Account table for accounts, amounts and data
 

obiron

Active Member
Joined
Jan 22, 2010
Messages
469
your IFRS table does not need all of the additional fields from the Account Table, only the Account Number. This is the nature of a Relational Database.

There is a relation (Account Number) between IFRS and Account. If you know the IFRS record, you know the Account details because you can get them from the related Account record.

Your select statement would then look like this:

Code:
SELECT 
    A.*,
    I.* 
FROM 
    Account A 
  JOIN 
    IFRS I on A.Account = I.Account
WHERE
    A.Account = "012345"
 

Forum statistics

Threads
1,082,250
Messages
5,364,020
Members
400,774
Latest member
Goldi paul

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top