Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...
Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an issue. Please review the recent post, whenever you have time and let me know what is possible solution. Thanks for all your help
When I am editing my Access dB on a network, a PC name, not my own, appears next to the Citrix icon, namely rdrwrajr0304, at the bottom right hand corner. Is this a snooper?
I just need code which hides the Access DB window and only have the open form. I have two more options in the form to which shows a report and one which saves the report as a excel file.
You asked what is does Program mean. It is actually the classroom identification for that staff person. there are several staff who would not have that due to staff who do not work in a classroom or staff who are "floaters" or AN(as needed) who are not assigned to 1 particular classroom.
We can forget the PIR Table. this is keeping track of all staff who had been hired and left during the program year. But I will have this information one my DB is done correctly.
ok...I'm ready to tackle the issues with my current database. As you know there's a lot of work to be done. Where should I begin? You suggested combining some tables and changes their PK and creating FK. I'm ready whenever you are able to help me to get this done right and most effective.
Thanks. I've just replied in the thread. Will do so if I find the time
BTW did you see my PM reply regarding SQL Server security - before Xmas I think.
If possible, please respond by PM or email ...definitely not in an open forum thread or profile message for reasons that should be obvious