Search results

Hi All, How can I add record(s) to listbox from combo box? Is it possible in Access? Please guys need your help. Thanks and more power. Regards, Jerry

Hi James, additional info: I alread populated the values on the combo box, just want to pick names on the combo and put it on the list box, so that I can get values from listbox to print. Wherein I can put as many names I want from combo to listbox. Hope it's not confusing for you...

Hi James Dudden, Ok here's my situation: I have a form with combo box and a list box, and I have also a report that shows the list of person i want to print from the listbox. All i need is to pick names on the combo box as many names i want to put it on the listbox and then i want it to print...

Hi All, Please help, I have combo textbox value and I want to transfer it to list box. Number of Record to transfer is indifinite, how could i transfer it. Please help me guys. Thank you and more power. Regards, Jerry

This time, I would like to give you thanks and I did it very well, ofcourse without your help, i dont think I could made. You mean a lot to me, thanks for all the help. I'll keep in touch with you Mike375 for my other things that really made confusing. Best Regards, Jerry

Hi Mike375, I'd like to thank you for your help to all my questions, I really appreciated it. I did you email re the top 3 frequent calls and it works. My last concern is, how do I put "DESC" order on the SQL, I tried to add it on the 2nd field after GROUP by but it didnt work. After I ran the...

Thank you so much Raskew for your help. I have one more question if you dont mind. I ran a report query and the result is like this: Phone of Callers ----------- 9062521022 2041002522 6042011021 4166381083 9062521022 9062521022 6042011021 2041002522 4166381083 4166381083 4166381083...

hi speakers_86, I just did the query, but where can I put the expression "Top N" in the query? Please need your help. Thanks. Jerry

hi Mike375, I did what you said on your first reply, I created a query with 2 same field names, and used "E" Totals on the tool bar, Group By appeared on the first field and I chose Count on the second field. When I ran the query, it gave me incorrect values. I have an example, Phone Nos...

Hi All, I did a query about getting the length of a field value and it works for me (SQL Len()). Say phone number "94166381083" total of 11 numbers, I want to eliminate the first number on the left which is number "9" to get only the 4166381083. I'm having a problem on how to create a query to...

Hi, I am having a problem in solving to get the top 3 calling numbers. I m doing a call log sheet report to determine which number is the most frequent callers. Say i have 10 records of callers and 3 out of 10 callers is from 1-800-204-5255 toll free numbers. How could I write a SQL script to...

i have a problem on how to build an expression to Control Source on to calculate the total time in "hh:mm:ss" format. I tried to make a simple script in Access and it works. dim tot as date tot = Format([time1] + [time2] + [time3], "hh:mm:ss") but this is on Access script, i am having trouble...

Hi, Please I really need anyone's help, i was stuck on this problem. I need to create a report on call log sheet that will display the total time talk of a certain caller. I need to do this in Access script or SQL. say, 12:01:10 + 12:00:20 + 12:00:15 should be 12:01:45 Please if you have...

hi Sviggos, Yes, actually I am doing Call Log Sheet report summary. I created 4 different report with sub-totals. Now I need to create a report that display/print the 4 sub-totals. Can we make it in Access? Please help me with this. I appreciated your help. Thanks Jerry

Hi Everyone, I have 4 stand alone sub-report with sub-totals made in Access, is there any way how to pull the summary from sub-reports. I need to create a report that prints the summary of my sub-totals. Please help me. Thank you so much. Regards, Jerry

Hi Stopher, You're right, I need to summarize the total from sub-reports then put it in another summary report. How can I reference the text boxes in the sub-report? Thank you so much for your help. Jerry

Hi All, I did 4 different itemized report with subtotal on each page, I would like to ask anyone from you, if there's a way how to make a report to print the summary of subtotals of each report. Say for instance, I want to create a report that will display only the 4 subtotals. Ex: Subtotal...

Thank you so much. Appreciated.

Hi All, I'm creating a report in Access, and please if somebody knows how to put the total record printed on the copy, I'm asking your help. Say, I have 10 records on the copy, I like to put on the report at the bottom part, Total Record: 10 Please I really need to help on this. Thank...

Hi All, I am doing a query on Call Log Sheet. Here's the fields: Operator Int_Ext Calls -------------------------- 101 I 102 E 103 E 101 I 105 E 101 E -------------------------- On Int_Ext...