Search results

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

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

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.

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