Search results
-
A
Add records with specific ID number
Haven't got that right. It works now. Thanks! -
A
Add records with specific ID number
SELECT FINAL_SITE.Site_Information, FINAL_SITE.Date, FINAL_SITE.[CH-X], FINAL_SITE.[CH-Y], DATA_FROM_GIS.Lon, DATA_FROM_GIS.Lat, FINAL_SITE.Precision, FINAL_SITE.[Field Elevation], DATA_FROM_GIS.DEM_Elevation, FINAL_SITE.Comment FROM FINAL_SITE LEFT JOIN DATA_FROM_GIS ON... -
A
Add records with specific ID number
vbaInet hi! Sorry I'm coming back with my normalization problem. I'm trying to do the procedure you suggested in the previous posts with the expression Nz([UnionQueryName].Lat, [CH to Lat-Lon].Lat) in a new query and the problem is that it returns only the records of the 'CH to Lat-Lon' table... -
A
Merge tables and queries
This is it . It worked fine. I hope I get over with it.. Thanks. -
A
Merge tables and queries
Is like you have two excel files with similar columns and and you copy-paste the columns of the one under the columns of the other so that you have one file with all the data from both. Then you can type whatever additional data you want in the large file. How can you do that in access? It would... -
A
Merge tables and queries
I would like some help on how I could merge several tables or queries creating one final table. So far I created a Union query with the fields I want from every table and query but I cannot add data manually in there. I have to go everytime to the original files and add the data there. I attach... -
A
Add records with specific ID number
vbaInet hi! I was wondering if you had the chance to take a look at the zip file I send you in my last post. I understand that you might be busy.. Cheers -
A
Add records with specific ID number
Hi! I attached the zip file as described. Now what I want is to create a final table or query with all the tables and queries like in the Union Query (Final_Site). Let me know if it's anything wrong. Thanks! -
A
Add records with specific ID number
Ok I will attach a database here, right? -
A
Add records with specific ID number
Thanks vbaInet. It worked fine. I guess there is no way just to add them directly in the Union query? And one last thing: Is it possible to tell me in a few words how I could have added the data in one table as you said? Maybe I could do it now. Thanks a lot. -
A
Add records with specific ID number
No sorry maybe I don't describe it well. They were originally different files all of them. They were excel files which I imported them in access. Then I made the union query as we said. I don't know what the normalization is. -
A
Add records with specific ID number
No I mean it is the same type. They have different records -
A
Add records with specific ID number
Their fields had different names than the others if you mean that. I probably could rename them from the beginning.. -
A
Add records with specific ID number
It's a mixture of both. [Latzin_2009_Comment_extraction] and [Latzin_2010_Comment_extraction] are queries and the rest are tables. -
A
Add records with specific ID number
Probably there was another way of doing it but I wanted to join different tables with more or less same fields. So the SQL for the Union query is SELECT [Site_Information],[Date],[CH-X],[CH-Y],[Lon],[Lat],[Precision],[Field Elevation],[DEM Elevation],[Comment] FROM... -
A
Add records with specific ID number
Hi everyone. Sorry if this already exists somewhere in the forum. I have a 'union query' with three columns. First column is 'ID number' , the second and the third are coordinates Lon and Lat. In this query I have about 600 ID numbers but only the half Lon and Lat. Now I have the rest of the...