Output is generated in duplicate

[KNMSRK]

Hi,

I am a beginner to MS Access, trying to complete a simple project.

I have created tables and Queries, and the final output is generated in a table "GrossSalary". Actual data in Salary and OT tables are only 5 lines, however output is generated for 20 lines.
We have 4 different OT amounts are Calculated and the output is generated for each employee 4 times.
Please advice how to fix the issue

I cannot upload the Access Data base - please help

 

[hernantorres23]

Hi, we are pleased to help you, but please, put your data example, using XL2BB.
Note: If would necessary, pay attention to this post XL2BB 2 Square

In some cases, users are disabled for install an add-in. If this condition is applicable, share your file with Dropbox, Drive, etc.

Also, you can copy and paste your data, formatting until if look like your Workbook

 

[welshgasman]

Crossposted Output is generated with repeated rows - Access World Forums

 

[JonXL]

...

Actual data in Salary and OT tables are only 5 lines, however output is generated for 20 lines.
We have 4 different OT amounts are Calculated and the output is generated for each employee 4 times.
Please advice how to fix the issue

I cannot upload the Access Data base - please help

Can you show us your queries and describe the layout of your tables?

 

[Micron]

Answer was given at AWF.
Without seeing the data, the answer seems sort of obvious - OP has a Cartesian result: 4 records in one table x 5 records in other table = 20 records

 

[Micron]

cross posted Output is generated in duplicate
That makes 2 other forum postings besides here.

KNMSRK please read Excelguru Help Site - A message to forum cross posters

 

[welshgasman]

cross posted Output is generated in duplicate
That makes 2 other forum postings besides here.

KNMSRK please read Excelguru Help Site - A message to forum cross posters

Micron,

That links to this thread?

 

[Micron]

Howdathappen? OK, when trying to repeat the fact in different places...
Too bad this forum 'masks' the url, otherwise I might have noticed and had time to fix it.
EDIT - I have to retract that last statement...still trying to get used to this new-fangled look here.

New Member to Access Forum - Need help on the database created by me

Hi I am a beginner to MS Access and tried creating few tables and queries. We have Salary details and OT details and the final output is Netsalary generated in a new table named as "NetSalary" In the given data OT amount is for 4 employees and Salary is for 5 employees as one employee...

www.accessforums.net