Search results

  1. M

    Query for multi valued field containing several dates

    Sorry, I could not get it. If possible you may help with attached file.
  2. M

    Query for multi valued field containing several dates

    There is a "Dates table" containing fields "Dates_ID" and "Dates" (field format: "Date/Time"). The field "Dates" from this table is added in another table "Staff List" by selecting the option "Add Existing Fields" from "Datasheet Tab" with option "Allow Multiple Values" selected. This field...
  3. M

    Displaying first five non-empty fields.

    Thanks for all your views. Its good that you got my problem. I am not very experienced in access but have completed few simple projects. Can you please describe some procedure in short to solve this problem?
  4. M

    Displaying first five non-empty fields.

    Sorry to say that you are not getting my problem. I have a table containing 11 columns. First column contains students name. The rest 10 columns contains their marks in 10 different subjects. Each student has selected exactly five subjects. I want to create a report which displays students name...
  5. M

    Displaying first five non-empty fields.

    Hello Galaxiom! You did not get my problem. I have well organ.ised data.I have a table in access containing a field for students name and another 10 fields for marks in 10 subjects. A student has appeared exactly for 5 subjects out of 10. Now in a report I want to display exactly 5 subjects with...
  6. M

    Displaying first five non-empty fields.

    Hello! I am new here. This is something interesting and challenging. I doubt whether this is possible in access or not. I have a table in access containing a field for students name and another 10 fields for marks in 10 subjects. A student has appeared exactly for 5 subjects out of 10. Now in a...
  7. M

    Adding leading zeros to alphanumeric text

    Thanks gaby, for your efforts. It just worked perfectly! Thank you very much!
  8. M

    Adding leading zeros to alphanumeric text

    Sorry Dear, but *2 is displayed as *2 and not as *02
  9. M

    Adding leading zeros to alphanumeric text

    Hello! I am new here. If "2" is in field, I want display in report as "02". If "*2" is in field , I want display in report as "*02" i.e. if there is only one digit with or without *, then I want to add one leading zero to make it two digit. . I hope to get some help from experts.
  10. M

    Adding leading zeros to alphanumeric field

    Thanks Paul0, for your efforts. It just worked perfectly! Thank you very much!
  11. M

    Adding leading zeros to alphanumeric field

    Thanks David, for your efforts. I just coded it as =Right("00" & OldField,5) in a text box in report. Anyway I got the solution from Paul0 as posted in thread.Thanks once again.
  12. M

    Adding leading zeros to alphanumeric field

    Sorry Dear, but it doesn't work. It just displays 00 only.
  13. M

    Adding leading zeros to alphanumeric field

    Hello! I am new here. If "2 FF" is in some field, I want display in report as "02 FF". If "23 FF" is in some field , I want display in report as "23 FF" i.e. if there is only one digit on the left, then I want to add one leading zero to make it two digit. Please note that there is space before...
Back
Top Bottom