Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cantech2
  • Content: Threads
  • Order by date
  1. cantech2

    How to convert Numbers to Words

    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...
  2. cantech2

    Commiting form field data to database

    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...
  3. cantech2

    Modifying a field in a report

    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
  4. cantech2

    Calculated data shows in form, but not in table

    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.
  5. cantech2

    Assigning Positions to Students per subject

    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...
  6. cantech2

    Summation of report

    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 ?
  7. cantech2

    Grading

    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
  8. cantech2

    Linking combo boxes

    I have created categories and subcategories fields, I want the selection made on the categories combo box to determine the options available on the subcategories combo box

Part and Inventory Search

Back
Top