Search results

Thanks vbalnet. Will give the outer joins a try. Always though joins were to join horizontal (hope this makes sense) with tables together that only have 1 or 2 common fields. But I am new to this game so don't be surprised I didn't know this was also to join them vertically. Thanks again and...

I am using 6 fields to compare the data. These are as follows: From_country_id, To_country_Id, primary_product_id, secondary_product_id, month and year. Should I add an extra field to join these 6 fields into one field. Have been thinking about restricting the query to the selection the user...

Hi guys sorry for the delay in replying. Have already got a field with the source as an integer with the name held in another table. Could you point me to some examples on how I could use this field to create a query to show the data required eg data source d, then any missing data from this...

I'm thinking that future versions should be developed on something else but running out time to delivery this version. First two were IEA exports and imports. Which only cover a select set of countries but now trying to add GTIS import and export data which covers more countries. Yeah it more...

Hi Guys, Wondering if someone will be able to point me in the right directions with a problem with a query I am having. Currently have a access database which will have details of Trade of different products between countries. The Data comes from several different sources which are held in...

Hello Access-Programmers My name is Martin and I have been dealing with VBA in Excel for several years. After starting a new Job 6 Months ago I now have to work with MS Access and thanks to this site and a couple of others I am learning something new everytime I use Access. Been a Invisible...