Search results for query: *

Great!! It works. Thank you Andy!

Hello Andy, I export the queries with "DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9," The function name of the export command i added to the autoexec macro. When windows scheduler opens the database than the autoexec macro runs the function. So the "DoCmd code must open some of...

Hi, I have an access 2003 database which runs automatically daily reports. But i have to create monthly queries in the same access database which must run reports only the first date of the month. So if the case is first day of the month than the monthly should be executed. can i this with a...

Thank you both for your sulotions. The solutions of dhookom was the most easy one to implement in my report.

I built a access report (label_new) with a grouping on Unique ID. The report header contains customer iformation and the details contains the location where goods should be picked from. The report details looks like : AB1054 AB1064 AB1163 AB1173 But i want to print it on the label like ...

date and time is an option . How can i generate the sequence number in crystal 10 ?

Is it possible to add a unique number after each refreshment to my report ? Crystal report version 8.5

is it possible to fit the result of the report on one page ? i am using crystal report version 8.5

yippie!! this is what i was looking for . thanks for your exepertise

i am getting the error "string is reuired here" see !!! marks StringVar result; NumberVar i := 1; For i := 1 to ubound({?T-DOC}) do result := result + !!!! {?T-DOC} + chr(13); result;

sorry , i need more help . i want to combine numbers and text . for example : input AA123B AA123C result AA123B AA123C thanks

great! it works. Thank you all for you support.

when i use lbass's formula to display multiple values, i get the following result : "123654 to 125478" . I want the result as follow: Input 10 20 30 the report should reflect the same values. 10 20 30

thanks , it works . Is possible to change the formula to show discrete vaules ?

when i use the formula : totext(minimum({?T-DOC}),0,"")+" to " + totext(maximum({?T-DOC}),0,"") i get the error "message too many agruments have been given to this function

8.5

when i add the parameter to my reports (?T-DOC} it shows only 1 record istead the whole range

it is also possible without default values ?

can someone tell me if it is possible to create a parameter which is not based on a table . I just want to add a range of numbers on my report via parameter.