Recent content by Monti2

I have built an Access database which achieves the objective of taking a number of source files each month, and performing data manipulation (filters, lookups etc), to generate outputs files in the required format. In order to achive this there are several instances where I used "stacked...

Pat is indeed correct, and I have it working now. Thank you for your kind help. Regards, Monti

I need a query that looks at 2 tables and lists those unique combinations of data of the 3 fields in table 1 and table 2. All records in table 2 will also exist in table 1. What I want is those records in table 1 that DONT exist in table 2. For example: Table 1- Make - model - colour...

I am trying to export a query to .txt file. I have a macro which performs this export, however one of my fields contains values which in some cases have more than 2 decimal places. When I examine the .txt file it appears Access has rounded these values to 2 decimal places during export. It is...

Got it working now. Thanks for your help.

I am trying to run a query as folllows: I have a field in a table with 100 records called Colour, which contains 10 different colours. I am trying to set the criteria so the results contain all records except where the colour is "Black" or "White". I can achieve this by listing the 8 colours...

Indeed the data fields within the spec were set to Integer, and having now set them to Double the Decimals import correctly. Many thanks.

I am trying to import a .csv file which has several numeric fields containing values with decimal places. When I import the file using: -"Get External Data / Import" (without using a SPEC) The decimals are imported into the table correctly -"Get External Data / Import" (using a SPEC)...