Recent content by heathb

thanks guys, but that is a lot of work. As it is all manual, I'll look at amending the file before I pull it in. Thought as there is an option to exclude columns, there would be a simple way to exclude rows.

Hi all, Looking to manually import a text file, and ignore the first 2 rows so that I can get to the header columns. Have had a look around, and all the previous talk is about macros etc Attached is the screen shot as I import the file, (apologies for trying to redact some of the info), what...

closed and reopen has worked :) ??????????

Hi, jumping on this oldie :) Have a similar issue. Have an excel template that I have populated then imported and appended to a table twice. On the 3rd update (each update is a diff month of data) I am getting the Subscript out of range. Quite a few ideas on here, however I am just doing this...

My thought, but checked that with another IIf and that works fine thanks anyway

solved, not sure why though:confused::confused::confused:

Ladies and gents, having an issue with the nested IIf only returning on one leg. Output example attached The above works fine when set individually. I have checked around and obviously it is going to be a simple fix, but I cannot see it..:mad: As usual, all help greatly rec'd

Hi Uncle Gizmo, indexing the unique record has worked, manythanks

Hi, I have tried searching without much luck, so will ask I am building queries on tables that require updating as new info becomes available. These tables are used to link like information. At the moment, importing the table I can create new, append (which duplicates unless i just add new...

thanks for the help guys, enjoy your weekend :)

Hi Wehbyj & pbaldy Thanks, this is working really well. One last question hopefully. Please see attached, why am i getting a "Enter parameter value" for Net position??

some more screen shots

ok, that worked, obviously :) cheers. however, even saving the table, when I re run the query that field disappears, The query is make table and that deletes and re adds the table, have tried to add Expr1: [Buy_Sell] to the query but this brings up a input field. Have also tried to change...

Hi Guys, very rusty bod here so please bare with me I have a query that maps a few tables together for a single output, as usual :) I have a field "Net position" that I want to drive a new field so if <0 then S or >0 then B in table design I have a new field name "Buy_Sell" with a calculated...

Hi, I am now new to access, as I haven't used it for many years and a good few things have changed. Please bare with me if I ask really stupid questions Many thanks heathb