access 07 query

[msprin4345]

Hello All, I am currently new to all this access and database stuff and i was wanting and needing anyones help that is feeling generous with knowledge!! I am currently triyng to create a query to display all matching records from two different tables, and trying to add a calcualted field named "blank" and the last column that equals active if the "status" field is equal to active and equals Not Active otherwise.

I am currently in the process of pulling all my hair out because i have not clue!! any and or all... please help me with setting up a calculated field.

Thanks and Hello to everyone!!

~M~

[cori25]

Hello...

1.) Create a Select query and bring in the two tables.

2.) Create a join between the two tables(you must use a field that is the same in both tables in order to join them, ex.) Name, ID, Date, ect....) In order to do this, click and hold on the field you would like to link to the other table, now simply drag to the same field in the other table. You will now have a join, double click on the line connecting the two field and you will see "Join Properties", select 1 to only include rows where the joined fields from both tables are equal.

3.) In order to bring in a status field of "Active", just type "Active" in the criteria and this will only pull in the active fields.

Let me know if this helps