Recent content by pavol_b

  1. P

    Age categories

    hi, the proceedure to calculate age in years from a birth date is clear. but i have another issue, concerning calculaction of "age categories", like Junior, Cadet and Senior. the known value is again birth date. the age <= 15 should be like Cadet, <=18 should be like Junior and >18 should be...
  2. P

    filtering report via checkbox selection in a form

    Hi all, I'm trying to create a filter function for a report, based on checkboxes in a form. The checkboxes in the form should be connected with specifich fields in my query. Some basic fields, like ID, name, address, tel.nr,... will be constant and checkboxes like age, specialization, membership...
  3. P

    vizualisation in Sum function

    Thanks Thanks gentlemen, it's now clear it doesn't works like html scrit, where I can use /b for bold.... I'm newbee in Access :cool:
  4. P

    vizualisation in Sum function

    Hi, I have a report grouping sport classes and use following string: ="Tax from" & " " & [od] & " (" & Count(*) & " " & IIf(Count(*)=1;"member";"members") & ")" where [od] means class name and should be written in bold. How to achieve that? Thx.
  5. P

    Annoying report printing problem

    printout on too much pages indeed it could (i think it is) a problem of redundant space in your page size. if you open the report in design view, left-top shows a small "dot". in case there is some problem, the color of this "error indicator" changes to other (red, green,...) accordingly to...
  6. P

    ageclass problem in report

    Hi all, in excel I use folloving formula to calculate the ageclass (Senior "S", Junior "J" and Cadet "Z") for brthdate (dd.mm.yyyy): =IF(INT((TODAY()-E2)/365,25)>18;"S";IF(F2<=15;"Z";"J")) But now I'm trying to make a report(based on query) on same base - to calculate the ageclass. How to...
Back
Top Bottom