Search results

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...

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, 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...

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