Recent content by rob4465

I could do with some suggestions for getting data from 2 rows into one. To explain further I have a phone report table that I need to manipulate so I can run queries for graphs and stats. I've posted an image that will help explain. Basically the data I have shows the person's name on one row...

Good morning, I'm in the process of creating some primary Keys in a Access Database before I move them into another system. I'm doing this in Access as it's easier to manipulate the data. What I have is about 5 thousand company records. I need to create a Primary Key for each which is no...

Hi all - I'm in the process of doing a database conversion - one of the fields in the database I'm converting from contains some entries in a XML format 'basically a notes field'. If I extract one of these entries and save it as a .xml file I can open it and read it with Word. So I now have...

Hi there - I'm trying to sort out some code to count the occurances of some data in a field. Basically I have an ID field that has been created from an update query. The result is a couple of thousand names like: Smith-John Bloggs-Joe etc... What I need is some code to go through each...