Hi everyone,
I'm really confused here.
I'm creating a query for a report. There's one field that contains alot of text, the data type of this field is actually memo.
In the query, I'm interested in finding the first and last of records. I already new that if I would pick group by, the text in this field would get cut off, as if the number of characters are limited. So I've always used last of.
Now, I need the first of and last of for this record. The last of obviously works... the first of is a problem.
It cuts off my text!
So, how can i get this data into my report without it being cut off?!
Any suggestions are greatly appreciated, I'm stuck!
If this is not clear please let me know and I'll rephrase it.
I'm really confused here.
I'm creating a query for a report. There's one field that contains alot of text, the data type of this field is actually memo.
In the query, I'm interested in finding the first and last of records. I already new that if I would pick group by, the text in this field would get cut off, as if the number of characters are limited. So I've always used last of.
Now, I need the first of and last of for this record. The last of obviously works... the first of is a problem.
It cuts off my text!
So, how can i get this data into my report without it being cut off?!
Any suggestions are greatly appreciated, I'm stuck!
If this is not clear please let me know and I'll rephrase it.