Re: Compare two columns and place results in new table

On Oct 8, 11:39 am, pamela fluente <pamelaflue...@xxxxxxxxx> wrote:
On 8 Ott, 14:27, napate...@xxxxxxxxx wrote:





Hi everyone,

I would like to know if there is a quick query someone can help me
write for the following scenario. I think I can do this with VBA but
since this is suppose to be a temp. solution, I really do not want to
spend too much time on it.

I have two tables, 1 an old one which has work done in it with all the
necessary columns correctly populated with the data and the second one
I need which has the same columns but need to be fulfilled with the
data. So this is basically what I need to do.

Table1
A B C D E F
x x x x x x (x = data)

Table 2
A B C D E F
x x x (x = data)

What I need here is compare columns Table1.B to Table 2.B and Table1.C
to Table2.C and if they match, place the data from Colmns D, E & F
from Table1 to Table2 D, E & F columns. The catch is Columns B & C
have to match simultaniously, in other words I cannot just compare
ColumnB first and then compare ColumnC.

So if Table1.B and Table1.C = Table2.B and Table.C, then copy Columns
Table1.D, E & F to Table2.D, E & F.

Little bit of info on the data:
1. Both of these tables will be imported from an excel file (.csv).
2. Columns B & C are a combination of numbers and characters (i.e.
s4uuie).
3. Column B will always have data but C may be null in a lot of
instances (dont know if this will create issues when comparing null
values).

Please let me know if I can provide any more information to help
understand the issue here.

Thanks,

Nilay

Before seeing a possible way, let's make sure to understood the
question.

Let's see assume (watch for possible google line breaks):

----------------
Field A Field B Field C Field D Field E Field F
Any A1 Any code001 any C1 hello what 23
Any A2 Any code002 12 if boat
Any A3 Any code003 any C3 bye about love
Any A4 Any code004 any C4 car
Any A5 Any code005 any C5 flag near dear
----------------

and the second table:

----------------
Field A Field B Field C Field D Field E Field F
Any A1 Any code001 any C1
Any A2
Any A3bis Any code003
Any code004 any C4
Any A5bis Any code005 any C5
----------------

would the wanted result be:

----------------
Any A1 Any code001 any C1 hello what 23
Any code004 any C4 car
Any A5bis Any code005 any C5 flag near dear
----------------

?

-P- Hide quoted text -

- Show quoted text -

Hi pamlea,

The result is exactly what i'm looking for. Is there an sql statement
i can run which will help me do this or a short vba code that may help
me? I would rather run a sql statement if possible since this will be
a 1 time job for a few days.

Thanks,

.

Relevant Pages

  • Re: Compare two columns and place results in new table
    ... ColumnB first and then compare ColumnC. ... i can run which will help me do this or a short vba code that may help ... If it's not sensitive data, you can send the Excel file to me and ... Providing Access Users with the world's best Reporting Solutionhttp://www..datatime.eu/download.aspx- Hide quoted text - ...
    (comp.databases.ms-access)
  • Re: Compare two columns and place results in new table
    ... ColumnB first and then compare ColumnC. ... i can run which will help me do this or a short vba code that may help ... Thanks,- Nascondi testo tra virgolette - ... Providing Access Users with the world's best Reporting Solution ...
    (comp.databases.ms-access)
  • Re: Basics of VBA and SQL
    ... Dim strQry As String ... The DoCmd.OpenQuery method requires the NAME of a saved query, ... Using a SQL statement in VBA would require the DoCmd.RunSQL strQry ...
    (microsoft.public.access.modulesdaovba)
  • Re: Basics of VBA and SQL
    ... Dim strQry As String ... The DoCmd.OpenQuery method requires the NAME of a saved query, ... Using a SQL statement in VBA would require the DoCmd.RunSQL strQry ...
    (microsoft.public.access.modulesdaovba)
  • Re: Without Matching Query Limit ?
    ... "John Spencer" wrote: ... I did start with the wizard and hand rolled from there. ... I could write vba to loop through each record and compare but I thought I ...
    (microsoft.public.access.queries)