473,320 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Need to find mismatch fields

1
Hi , i have 2 tables in Acees, table A is Company and table B is Merging_Company.

Company Contains the following fields

CODE , DESCRIPTION , UNIT ID

Table Merging_Company Contais the following fields

CODE , DESCRIPTION , UNIT ID


I am consolidating the company table record in to Merging_company table with the UNIT_ID, This UNIT ID represents the Unique identification between companies.

My requirements here is,

[1] I need to cross verify that number of records in each company in the company table must match with the records in the Merged_company table

[2] Need to find out mismatching code or description between two tables for each company.

Pls help me in building this query

Thanks
Ysn
Sep 22 '06 #1
1 6388
Hi , i have 2 tables in Acees, table A is Company and table B is Merging_Company.

Company Contains the following fields

CODE , DESCRIPTION , UNIT ID

Table Merging_Company Contais the following fields

CODE , DESCRIPTION , UNIT ID


I am consolidating the company table record in to Merging_company table with the UNIT_ID, This UNIT ID represents the Unique identification between companies.

My requirements here is,

[1] I need to cross verify that number of records in each company in the company table must match with the records in the Merged_company table

[2] Need to find out mismatching code or description between two tables for each company.

Pls help me in building this query

Thanks
Ysn
------------------------------
Use the query wizard to help you get started. Select query/new/find unmatched query wizard.
This will help you to build a query checking one field in Table A that is mismatched/missing in Table B you are comparing to.
When it is finished, Notice in query design mode that the table B field you selected does not have 'show' checked on and its Criteria = is null.
Now you can add the other Table B fields to your query that you want to mismatch so you then have the complete combination. Remember they are 'no show' and criteria = is null.
What you are doing is lookng at table A to see if table B has that value. If not in table B, then it is NULL for table B.

Below is the SQL for a query I have in one of my d-bases.
SELECT KapesDistProdOper.Product, KapesDistProdOper.Oper, KapesDistProdOper.Task, KapesDistProdOper.OperAndTask, KapesDistProdOper.Description
FROM KapesDistProdOper LEFT JOIN REPORT_HSSAP04 ON KapesDistProdOper.Task = REPORT_HSSAP04.task
WHERE (((REPORT_HSSAP04.Prod) Is Null) AND ((REPORT_HSSAP04.Oper) Is Null) AND ((REPORT_HSSAP04.task) Is Null))
ORDER BY KapesDistProdOper.Product, KapesDistProdOper.Oper, KapesDistProdOper.Task;

Hope this helps,
jkantner
Sep 22 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Stephen Briley | last post by:
For some reason, my posts are scrubbed as attachments. Lets hope that sending from the yahoo account works. I'm new to Python and I'm trying to do some database work with MS Access, but I can't...
2
by: Steve Briley | last post by:
I'm new to Python and I'm trying to do some database work with MS Access, but I can't seem to get around a "datatype mismatch error".  Here's an example table that I'm working with... ...
11
by: Jim | last post by:
Hi, I keep getting form results emailed to me that would indicate a form from my web site is getting submitted with all fields blank or empty, but my code should preventing users from proceeding...
2
by: mychevworld | last post by:
I'm getting a type mismatch error on the mid(strRecord,1,1)="H" line. I used to do this all of the time, but I haven't done any VBScript for awhile, so I'm sure I'm forgetting something. While...
1
by: Karl Irvin | last post by:
I copied the following code from the MS website. It compiles OK but gives a type mismatch message on the line that says: Set Flds = iConf.Fields What needs to be changed? Also can I use this to...
9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
3
by: Martin Lacoste | last post by:
Is there some issue with using too many left/right/mid/len functions in queries? Depending on the usage, they work fine, but... then there's here: SELECT Master_CAO.Incipit,...
1
by: EdwardH | last post by:
Hello All, I 'm having problem with a comException - Type Mismatch error, I have checked the data types in my table which resides in an Ms Access database. A snippet of code is posted below, the line...
3
by: Nepenthen | last post by:
Hello – I am still new to Access and I am currently working on debugging some code. I have a form with the following: Employee Name (combo with select all choice) Task (combo with select all...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.