Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Row Numbers or Autonumber
I have a situation where I've got multiples of an item that I need to make unique. I can find them using a find duplicates query. What I want to do is append them to a table that has an autonumber field and then use that number to append to each duplicate to make it unique. For instance, two...- PRIreland
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
Carriage Return or New Line in a Concatenated Note
This is a follow on from an earlier post where my problem was with Access. Now I'm in Excel and want to force a new line in a cell. When typing this manually, Alt-Enter causes a new line with a cell. Is there a way to make this happen when concatenating text? I know the command sequence...- PRIreland
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Carriage Return or New Line in a Concatenated Note
How can I encode a carriage return in a concatenated field? I've got some text that looks like this (say this is from a field called [Q_TEXT]: THE PART IS QUOTED AT $3.25 MARKUP 1.25 When I run a query, the text will print just like this and that is what I want. It also comes out in a data...- PRIreland
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Automatically Name Reports
I have a couple thousand reports to create as part of a data migration project. The information is in a table and I'm using reports to put the data in a report format to be OutputTo in RTF format so I can use them as attachments, etc. I can't sit and type all of these names and am wondering if...- PRIreland
- Thread
- Replies: 19
- Forum: Microsoft: Access Reports
