report Duplicate date many time pls help

[shendy20007]

i try to make report to explains date out & date in for the equipment when i try it gave to me wrong & Duplicate the date

D IN	hour in	D OUT	hour out	CUSTOMER
17/03/2006	6838	10/10/2006	7432	شرم الشيخ
17/03/2006	6838	17/03/2007	8444	شركة بيبسى
17/03/2006	6838	29/09/2010	16686	يونيون اير
17/03/2006	6838	24/08/2010	16671	شركة 21 لأنتاج الألمونيوم
17/03/2006	6838	12/06/2010	16134	شركة البابطين
17/03/2006	6838	28/06/2008	12820	المقاولون العرب
17/03/2006	6838	07/10/2007	11843	المقاولون العرب
17/03/2006	6838	11/09/2007	11618	م/رانيا جعفر
17/03/2006	6838	10/05/2006	6838
17/03/2006	6838	08/03/2007	8391	شركة سيجما للأدوية
17/03/2006	6838	02/03/2006	6668
17/03/2006	6838	17/05/2006	6886	سركة جيوم للبترول
17/03/2006	6838	20/06/2006	6839	القطامية
17/03/2006	6838	29/07/2006	7094	يونيون اير
17/03/2006	6838	31/08/2006	7420	فيلا بطرس غالى
17/03/2006	6838	04/12/2006	7517	ماسترجاز
17/05/2006	6886	17/03/2007	8444	شركة بيبسى

[alansidman]

Can you give us more information. What does the first table represent? what does the picture represent. There appears to be no duplicates listed here. Are you using a query as your recordset for your report. You have not given us enough information to help.

[shendy20007]

sorry my friend i have 3 tbl
1 for equipment cod & its specifications (tbl1)
2 for date out and count for hour out (tbl2)
3 for date in and count for hour in (tbl3)
and i try to make a report by using a query but it give me the seem result
and try to make by report wizard also seem result
i want to make a 2 reports
1 give me the date out, hour out and customer from tbl 2 and date in hour in from tbl3 and equipment cod from tbl1
this report for all equipment
2 report give me the seem information but for 1 equipment it ask me for the cod
thanks for your help

[shendy20007]

pls help me

[alansidman]

Since you have chosen to explain your issue in English but show your tables in both English and Arabic, it is difficult to understand the relationships. Please show your tables with English translations. Additionally, if you have prepared a query, please show us your SQL statement (again in English) that relates to the tables so we can better understand what you have created and how to present what you need.

[shendy20007]

i try to help you as i can thanks for your kindly

[alansidman]

I believe that your structure of your database is your primary issue. I think you should read this white paper before you go much further in data base development so that you don't experience this issue in the future.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

Now, I have taken your information from your thread and created a db that if I wanted the data you ask for would use. Look at the structure. I am not suggesting you use this, but use the concept to understand how to achieve what you are trying to do.

[shendy20007]

dear sir thank you for your help .but i would tell u i try this solution but the issue is i know the date out of equipment but i don't know when it come back .that is mean i have 2 table one for date out and other for date in .i will send to u my suggestion



but the query not work with this relationship . and i attach the file to see where the problem
thank you for your help
Database7.zip

[alansidman]

You should only have one table for the movement of the equipment. Your db is not normalized when you have repeating data in two tables. Did you read the white paper on the fundamentals of relational databases? If you only have one table then you can see at any time what equipment has been sent out and not come back by filtering on the date return field with the criteria "Is Null"

[shendy20007]

how can i return to the record of the equipment to enter the date in by simple steps

[alansidman]

1. You could create a lookup on your form to search for the record by customer
2. You could filter your form to return all records for a particular customer.
3. You could search for the record on your form by equipment number.
4. You could have a query that returns all items that have been delivered and not returned.

You have many options. Have you studied any tutorials or purchased a book to guide you on databases?

If you have unique identifiers for the equipment or the customer, you could use them to filter your forms. Either way would work, but I would prefer the equipment ID as that would be more beneficial.