Recent content by mathsbeauty

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

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

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?

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

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

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

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

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

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.

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

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.

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

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