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~