Sunaj
I solved my problem by searching through the archive (for a long time!!). I can now get all the ordernumbers out of the string.
Thanks for your help anyway!!!
Regards Corine
Sunaj, thanks for your answer.
But, unfortunately it didn't work. I corrected it a little bit (movenext for example :) ), but then I get the same as my solution.
The problem is the linefeed in the textstring. When the "order" is on the next line, you get strange results. Therefor I...
People, Maybe (possibly!) you can help me.
I converted a foxpro-table into access. One field is a memo field, in which linefeeds are used. The field might contain the text "Ordernr: 12345". This can be on the first line or on the second or third etc. The memo-field is never longer...
THANKS
I am gonna look at it this evening!
Saw that you were looking for rtf documents. what about the export utility. In that way I export txt-files. Other file formats are also possible.
Corine
Hopefully anyone can help me.
I would like to change the blue collor of the upper bar, the bar in which is standing the yellow key, "Microsoft Acces", etc.
Is this possible?????
Corine
Aart,
You are working with MONTH, I need WEEKS.
Your solution works for monthes...... and that is possible with the format function, but now weeks
Corine
Problem with your solution is that if the weeknumber is 9 or less, the sorting won't work, because the field will be
20001 (jan 2000) instead of 200001
Watch the number of zeros, 3 / 4
So, unfortunately your solution won't work as far as I can see.
Thanks for warning for the missing values...
In a table I have a date-field called "Date"
Now I must make a crosstab-query with a field yearnumber-weeknumber and group by on that field. The weeknumber must alwyas be 2 digits long because I have to sort on this field (descending).
Hopefully someone can help me
Thanks
Corine...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.