Search results for query: *

Dear M8KWR, I am VERY VERY VERY happy !!!! You have made my day. I discovered my error, I was to put the spellnumber in CONTROLSOURCE and not NAME field. I am in Nigeria and was able to edit the code so that my figures are now translated to Naira and Kobo. God bless you, Cantech2 (Humphrey)

Dear M8KWR, I am not out of the woods yet ! 1. I have succesfully create the module. Thx. 2. In the module, OBJECT reads General, while PROCEDURE reads SpellNumber. Are these alright or do they need to be changed. 3. In the properties box of the field in question, the tab called other has...

Thanks but I am still lost. I am a user and not a programmer and I would deeply appreciate your patience. Assume I am in the design view of my report, how do create a new module. Thanks

I have a field called GROSS in a report which is based on a mathematical calculation of other values. The value of GROSS therefore changes. I want GROSS to display word and not numbers. Eg if GROSS is 10200, I want it to be displated as Ten Thousand Two Hundred. I am a novice and need a clear...

Hello, I have a form called BILLS with a field called LABILL I also have a subform called LABTEST with a calculation field called TOTAL. I have set the value of LABBILL to be euqal to the calculated value in TOTAL. The above works well on the form but does not show up on displayed on the form...

Dear Jesse, thanks for your response I was hoping I would avoid creating a new field since the current field is part of a summation formula elsewhere in the report. Is it possible to apply a formula on the existing field. Thanks, Cantech2

I have created a report that works ok. I saved the report with a new name hoping to modift some fields eg. OLD REPORT has a field called [SALARY] In NEW REPORT, I want to multiply the value of {SALARY] by 2 or by 50%. What do I do Thanks, Cantech2

Dear Duane, thanks for your assistance so far. I have a tricky headache. Now, the ranking works on the whole table, which is fine. But if I put a criteria to give me the result for the boys only, it still gives me their positions in the whole class whereas I want to see the new position of a...

I have a table called STUDENTS, some of the fields are SCORE1, SCORE2 AND SUM. On the form generated from the table, the control source for SUM is =[SCORE1]+[SCORE2]. This works nicely on the form but the calculated figure does not show up on the table. What should I do ? Humphrey.

Dear Duane, thanks so far. When I try to execute, I get the following error message: "You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one...

Next question: Now, on the same report, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page break after each...

Next question: Now, on the same report, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page break after each...

Dear Dhookom, thanks for your response but I am not clear on your solution. Please see additional information: 1. My table is SS1 2. My the score field on the report is English 3. The position field on the report is Position 4. If 2 people have the same score, they should have the same...

I have a class database from which I have created a report. Now, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page...

Jim, thanks. I checked my table and they were text fields. I changed them to number fields and my report is. Ok. God bless you, Cantech2

I have 2 fields on a report, one is TESTSCORE (50) and the other is EXAMSCORE (80). When I create a text field on the report to add both fields ie =[TESTSCORE]+[EXAMSCORE], I get 5080 instead of 130. How do I resolve this ?

Thanks CajunCenturion, the switch function you gave was simple and perfect for my purpose. God bless you, Cantech2

Dear Bluekestrel, your solution was wonderful. I implemented the combo box relationships and it worked. I was able to do this for upto 4 subcategory levels. Thanks and God bless you, Cantech2

Dear Jrbarnett, thanks for your last response. Was wonderful. Next issue: I could implement the event on the form. However, the grades do not show up on a report and I dont see the option to build an event there. How can I get the grades to function in a report. Thanks, Cantech2

In Microsoft Access, on a form where there is a score field and a grade field, how do I program the grade field to automatically display A, B, C, D, E or F depending on the value in the grade field