Search results

more info... I just noticed the post did not display the example properly. Depending on the size of the number, the spaces between them vary. Sometimes it's 5, othertimes it is 4. Anyway, the actual problem file is now attached. You will see the five columns of data further down.

Hi everyone Here is an example of a text file that I am trying to import into an Access table: 2.100 157.3 -999.25 4000.0 -999.25 2.200 139.1 -999.25 4000.0 17.0 2.300 122.7 -999.25 4000.0 16.2 2.400 131.8 2.27 4000.0 16.1 2.500 140.9 2.44...

Hi guys I have a personal financial database that I want to use VB code for to predict when bills are due. I have figured out how to update weekly, fortnightly and monthly expenses but the trimonthly bills are what I am stuck on as they are unique. I need to filter my tblRegularBills table to...

I tried using the instr function but this does not work. Expr1: InStr([Andrew].[Payer/payee],[categorys].[raw category]) With this expression it will only work if the raw category entirely matches the payer/payee, which is no good - I would have to make infinite combinations of spaces and...

Hi all I have a financial database that gets downloaded transactions off the internet from our accounts. The problem is that the transaction payer/payee is not always unique and needs to be classified. This is easy done using If statements but I really want to enter parts of the string into a...