Recent content by Joyce

Well, as you might have figured out by now I'm pretty much a noob. :) But i did it! My first own function. :) Thanks for the help!

I really appreciate all your help! I have to fit this into a query and thusfar I have this: test: InStr(1;[tbl_energierapportage]![TransactieOmschrijving];Left([gebouw];4)) which of course gives me the first position of where the string starts. now I want something like a Mid test+3;2 and...

yes, the 4 digit buildingnumber is always followed by the 2 digit month number. its just that this string of 6 digits is not always at the beginning of the string. the 4 digit buildingnumber is in a different column.

no logical pattern thanks to manual input. all I can think of is that it should look for the XXXX and then count from there and display the 2 numbers after that.

about a 1000 for 2010 only :(

You are very right, unfortunately I've only been working here two months and we're talking about data starting from 2005 and its too much to correct right now, so I'm really hoping there is some solution.

What function to use when looking for part of a string? Hmm, I've been wondering how to explain this. I have a column that is either filled through a query, but also with manual comments. So as you've guessed they don't always match in layout. The layout should be XXXX (building number) XX...

Hmm, my XML looks totally different. This is what we receive from our suppliers (data has been altered): Now there are around 80 of these in one XML, this one has only a few nodes, there are some invoices with twice as many nodes. When importing just one invoice I have no problems, when...

I have no idea why. :) Just seemed logical. I just have no idea what you mean. Here's part of my xsl: and But now I've run into a different snag. negatives are displayed like this in de XML: 1234.15- Now I can use an import specification to replace the . with a , But it doesn't reckognize...

omg! how simple can it be. :) I love you! Its working :)

so you build a script around the importxml per element?

well, thats going to be a problem since the file contains confidential data. It contains invoices with and one XML file contains around 80 invoices. In total an invoice can have 51 elements, but not all invoices do, some have only 20 or 30, depending on what is being invoiced. When importing the...

XSLT is not Excel, its a css for XML files. Supposedly in Access 2010 you can even transform an XML in the GUI with a XSLT, but that doesn't work. The date notation is like this: YYYYMMDD, Access hasn't been able to define that as DDMMYYYY. But how do I do this simply: it might be worth...

Actually I work in Groningen, so that wouldl be 2,5 hours. :) I put a test database here: http://www.joycewolthuis.nl/wp-content/uploads/2010/05/test.mdb let me explain the purpose of this database. Every month we receive energy invoices from Essent, about 80 to a 100 each month. Combined in...