Repeating Records

[windwardmi]

I have a Time Card Form where I input employee daily hours.

Also I am designing a Time Card Report to print out weekly records.

The Records keep repeating themselves when I open the report. See Attachment.

Any help to correct this would be great?

[TheShabz]

Check the query that the form is pulling the data from. view the query in datasheet view and see if it is returning the data as you desire. It's probably an issue there. Most likely, you will just have to "Group By" in your query to get what you want. Also, you have unread emails in Outlook =P

[windwardmi]

Unread Emails?

[TheShabz]

your word doc contains a screen shot. in it, in your system tray, it shows the Outlook icon for unread emails. just lookin out for you =]

[Access_Blaster]

Ha ha that is funny, a little obscure but funny

[windwardmi]

I looked at the query and it does show repeating records in datasheet view. What could be causing that.

[evander]

Looking at your screenshot, I think the query that feeds data into your report probably consists of two or or more tables that lack the appropriate relationships, thus creating a cross join. More into this when I get a reply from you.

[windwardmi]

That's true. I was reseaarching that also. Any guidance? I have to run and be back i evening. Any help is appreciated.

[evander]

I need you to create a screenshot of your database relationships and post it here. Hope it's not that complicated. LOL.

[windwardmi]

Your have to tell me how to add it here directly. Do I use some sort of code. I can't copy and paste. Pardon my limited knowledge.

I did attach the print screen version.

[TheShabz]

Oh God. I cringed when I saw that query.

First off, evander was requesting a screenshot of your relationships. To get this, click on Database Tools and then Relationships. take a screenshot of that.

As far as the query you just posted goes, get rid of all the ones you dont need. From the query, all you are pulling info from is "time billed", "projects", "and employee names"

Now assuming al the "ID" fields contain the same information, you will be joining the ID fields in the remaining objects (i say objects because not all are tables. you have queries there too). To do this, click on the ID field in the list box and drag to the other ID field. a line will show up. This indicates that they are joined on that ID. so what you pull from one object will only relate to the matching ID of the other object.

Now run the query and see if the information that shows is what you want.

[windwardmi]

I will look at this closely and come back with a better picture of what I want as a final result. Please be patient with me.

[evander]

Sorry I was late in my reply. I'm from the Philippines, so we live in different time zones. The Shabz's right. You need to set the relationships in the Relationships window first.. Then:

a. What do you want your report to look like (what fields do you expect to appear)?
b. Where can you find those fields (which tables)?

Plus, you need to understand important concepts in database (these are the concepts I usually emphasize when giving tutorials):
a. Primary keys and foreign keys
b. Relationships and "Enforce Referential Integrity"
c. Joins
d. Normalization
e. Master-Header-Detail table structure (related to normalization)

[windwardmi]

Attachment 1124

These are my relationships.

I started from a MS Template "Time and Billing" and I am trying to automate some of our day to day record keeping by adding additional tables, forms and making reports to print out hard copies.

One form is our employee time sheets for the week. I hope to have the employees add all info for time spent on projects quickly by using the following form with combo boxes showing Projects, Locations, Employees, Vessels, Work Code, Work Type and than add start time, end time and hours. Finally having supervisor note it was approved. A Report will then be printed for each employee noting 7 day interval for payroll purposes.

Right now I'm working on the form and report. GOING TO DINNER NO NEED TO COMMENT TILL SUNDAY

Attachment 1125

Attachment 1126

Attachment 1127