Search results for query: *

Hi Everyone! I need to have records on two tables having similar structure with an employee code like "0001" and store it on a temporary table with the same structure.How am I gonna do it? Can I use query to pruduce the results? Thanks

Pete, I am wishing you all the best and great things to come. Thank you for the the great help you've done. More Power to YOU! You are very welcome to drop by. Wendz edbb@lycos.com

Hello! For a more clearer picture of my problem. It runs something like this. if field1(Gender)==Female display contents of field2(FemalePref) else display contents of field3(MalePref) endif How I am gonna implement this on the report. I have tried to implement this but it just display...

Hi! Thanks for all the generousity of answering my questions. I hope you would not be tired of answering my questions. Can I assign a field to a variable? I tried to use the IIF command in Print When but it does not work. Whats the best way to do it? Wendz edbb@lycos.com

Thanks you all for the tips. I appreciate it very much... Wendz edbb@lycos.com

Thanks Pete. Im having three tables related by autocode. This three tables are: 1st table consist of primary reponsibilities, 2nd table specific responsibilities and 3rd seminars attended. This three tables should be in one report with each table having separate fields on that report. Can I...

Thanks to all of you:). I think this would work now. By the way what I am going to sort is the day only since I have already filtered it by month. Wendz edbb@lycos.com

Hello! I have a new problem in printing the contents of the different unrelated tables, three tables to be specific in one report. I tested to have it in one report but it will display only the first record of each three tables. How I am gonna display all of its contents in one report? I can't...

Hello To All, I have a question regarding day of week in reports. I am making a report for birthday celebrants and I have filtered it according to the months of the birthday celebrants. My problem is how I am gonna sort the days of the birthdate like; 01/12/1990, 01/02/1989 and 01/13/1998. How...

Thanks foxdev for your suggestion. I thought that there is also an equivalent command of setall in doing that report. Anyway, I have taken your advice and it is working right now. My only problem is displaying my fields on a separate detail band since I have fields which must be displayed on a...

Thanks Vlad and Dave ofr the tips. Dave, can you kindly give me a sample command on how sql works in renaming fields and to import? My temporary solution before works only if I separate that fields on a detail band of every page. If only a multiple detail band is available. Anyway, I'll try your...

Hi! I find this problem very difficult and I hope you will ben still generous to share for what will be my effective solution. My problem is: I have Fields like Educational Backgound, Work Experience and Organizations. I want this to be displayed in same page. What I know that it would be best...

Thanks Robert and SGLong for your quick and good tips. Actually what I have questioned will be applied to the detail band would be this way: Photocopy Original Remarks Marriage License Yes No (memo) Birth Certificate Yes No I have lots of...

Hi to all! How do I put special characters like a checkmark instead of .T. or .F. on the report? I find difficulty on this part. Hope you can help... Thanks Wendz edbb@lycos.com

Thank you guys for your tips. I'll try to implement it and be back with the results. Wendz edbb@lycos.com

Hi To all! I am designing a utility that will back-up files. I have a short program like this: local tdir, sdir sdir="c:\sps\data" tdir="d:\sps\data" if !empty(tdir) wait wind "directory found" nowait set defa to (sdir) else wait wind "directory...

Thanks Vlad... Wendz edbb@lycos.com

Yes! it works....Thanks a lot. Is there a way that I can sort the fields aside from the primary key. How about if I will sort the field according to Family Name on the report? Thanks again. Wendz edbb@lycos.com

Thank you Guys for the quick tips. I hope this would br ok now. More Power To You! Wendz edbb@lycos.com

Hello Guys! I hope you will still help me with this problem. I have a report which is supposed not to display the dates if it is blank. It should only display the data like date_of_exit if it is not blank. I have used on the properties of a field display when NOT BLANK(org.date_of_exit). It...