Good afternoon all, forgive this being my first post but i am so angry I just dont even know what to do.
My problem is this:
I have a datebase. I have 2 main Tables (called new store and Rent Data). I have them linked by a primary key on a one to one type (include all records from rent data and only those of new store where the joined fields are equal.)
I have one query that takes specific data from my two tables. the main point of concern being my status (only extracts certain data that is "pending approval")
I have a report generated off this query however when i "test" it and mark only one item "pending approval" it generates approximatly 60 something lines and repeats it over and over again. i can not get it to pull the report with that item being listed only 1 time.
someone please help!
Thanks
~Grofica