Search results for query: *

Thanks Lespaul... Worked like a charm!! Much love!!!

Ok I am very rusty and under a deadline. I need syntax help with the following Query. Select * From SvyDtl Where SvyDtl.SdPrjnum = ClsdPort.CpPrjNum. Any and all help is appreciated.

On the money as usual !!! Have a star!!!

I'd like to use the results of two querys to create a table. Both contain the same column names and properties. Can you help with the best approach? I tried teh wizard it was a not go? Pprobably ID10T user error :)

I think the second query will give me what I need. Have a star!!! Tks!

Both are number field s but no calcs are necessary just a match. Does the format function give me value in this area?

The fields that i am trying to join on are both serial number fields. T1 contains the entire number t2 contains 5 digits of the serial number.

Limit it how?

I would like to create a join using a range. Do I need to indicate that the match will be a range of the field in the second table?

Beautiful!!!!! Thank you both so much.

I am going to give them both a whirl. I will keep you posted Thanks!

Let me explain. I have two tables that I would like to compare. Table1 and Table2 both contain the same data , but for the different apps.The building_code is the relationship I'd like to 1) Group or sort each table by building_code. 2) Obtain a building count(total) for each building_code...

Good Morning!- I need to create a query or report that will sort a table by building_code and return/display the total. The table doesn't currently have a numeric field to use to count.

The query ran sucessfully. Thanks to All! It updated changes to 178k rows. My table only contains 122k. Can I assume the other 58k are due to the cartesean join issue and that because they are not present my table row count, that they do not impact my result table?

The relationship between the two is that address1 and building_name are the same. Allstation contains all necessary info for analysis except the building_code from Netcatch, which I mapped as GRDLBldcode in Allworkstation. Allworkstation ( there are 20 field names in this table) comp_ id...

Allstation.building was not the name of the field it is address1.I corrected it and it is running.I will keep you posted.

Its actually Allstation.building_name

Thanks PHV. Access is asking me to enter the Parameter value for Allstation.Building name. this concerns me. I need teh values to pull from table 1 (netcatch)

1)I created a column for the new field(GRDLBldcode) in table 2 (all workstation) 2)I plugged my tablename/field information into the statement. UPDATE Allworkstation INNER JOIN Netcatch ON netcatch.building_name= Netcatch.building_name SET Allworkstation.GRDLBldcode =...

a1 and A2 are these table names or field names?