Recent content by Rogeman

Thanks Pat, Your answer was a bit above my ability, I read it many times but decided plan "B" was next stop, ask the wife what she really wanted. It turned out that she needed the labels printed out for each days new entries, not all of them. This made it easier as I could now use ">=Date ()"in...

Hi, I have a database :- female male Surname Anne Adams Bob Brown Clare David Evans ...........> I need to end up with labels as follows:- Anne Adams Bob Brown Clare Evans David Evans...

Hi All, Thanks for all the different answers to what I thought was a simple question, I did not realise that it would be such a complex task. Should I conclude that most people just create postal labels manually in their reports rather than get Access to do it for them. I am a great believer...

Hi Brian, A good look in the Help files and internet got me there in the end. I used your function in my Query an had the result I wanted, but got too adventurous and tried to adapt it and insert it in the same Query to give me just the Initials in another field, but no luck yet. This was just...

Thanks Brian, Your function did the trick, I did not understand how to create functions, but I think I do now,anyway when I inserted it in my query it gave the required results:). Roger

Hi Jack, I am still not achieving my goal, I enclose a view of my Query that I have showing my results. This is the code I am using :- Expr5: [title] & " " & Left([FORENAME_M],1) & " & " & Left([FORENAME_F],1) & " " & ([surname]) As you will see I still have an unwanted "&" before the female...

Hi Thanks for your reply. Perhaps I should ask the question in a different way. I have the male/female fornames in one column each in the table, entered from a Form. What I think I want to happen is that the Initials are pulled out from the forenames columns, I can then enter that field in the...

Hello, I am attempting my first database in access 2003. It is for a group membership. All has gone well until I tried to concatenate from a query and save to a table,so far so good, but this is what I have come up against and am unable to solve. The following gave me this result when creating...