I don't think you can write a blanket select statement that will get what you want. The best you can do, if you included a comma in the fullname field, is to separate everything into at least two separate colums Last Name which would be everything before the comma, and then First name and...
I have a database that keeps extensive data on response times, by date. I want to get the top 14 people who responded to EACH incident on a selected date. (There could be instances of 7 or 10 incidents per date and 14+ people responding to each incident)
I believe that some incantation of Top...
Hi all, I would like to convert a general number into a time format dynamically. Currently time is put in without colons separating the hours, minutes and seconds. It appears as such: 95904 I need the number to appear as 9:59:04 Is there an easy way of converting this text into a time format?
I want to password protect a powerpoint presentation or at the very minimum, make the file read only. Can this be done? I have a number of enterprising co-workers who like to tinker with things and make changes-often inappropriately. Can I by chance, make a file that has to be stored on a...
Any more suggestions? I can't set up security again as I don't have access to the Workgroupadmin file. Plus some users have been able to keep 97 on their machine so the database has to be used on dual systems. Is that going to create further problems?
I know I've asked before, and received an answer but I can't find it in my search so if you don't mind let me ask again, and be prepared to print the solution.
I know that I shouldn't print a form, but we have monitors that go out in the field and would like to take a blank report in paper...
Including the security, or would I have to set that up again. I guess my biggest concern with converting anything is that I cannot access the wrkgadm.exe file as my network locks me out of anything remotely address administration of something on the network.
My fear is that converting anything...
That means that you have both 97 and 2000 running on your machine? That also means that you can still access the wrkgadm.exe file?
I can't do either. Such a joy working with IT when they decide what you need to do your job, but that's another rant.
If you are saying that you don't have 97 on...
...user account doesn't have permission to convert or enable this database.
It goes on to say that to convert or enable, ensure the following:
*You must join the workgroup that defines the user accounts to access the databsae
*Your user account must have open/run and Open exclusive permissions...
Maybe I need to modify my original request. In light of what was said above I wouldn't have to use a begin date at all when I'm trying to find all those person who don't have an end date at all or ended 4/1/01 or later.
How would I write that? This is my formula so far which returns all the...
I want to be able to show records from the database where the beginning date is between 04/01/01 and 6/30/01 and exclude those records that in that date range that have an ending date that is greater than 3/30/01.
I can of get the report to work with either of these statements but not with...
Let me preface my request by saying that I searched in the keyword search and FAQ area for an answer prior to posting, but I must be wording my request incorrectly.
I am using a business day/holiday formula that I found on the Crystal Decision's Website to determine actual working days between...
Using PROPER in excel changes text to both upper and lower case. Capitalizes the first letter of the name and makes the rest lower case. . . Most of the formula's in Excel transfer over to Access but not this one. Any suggestions for getting text to convert to sentence case in Access? A...
We have a Novell Network and we have 28 users that need access to our database. I have set up security for all of the 28 people by various groups. The problem is accessing the system.mdw file. It appears that I will have to visit each one, to connect them to the proper system.mdw file which...
I want to extend my thanks to everyone on this list. This has been the MOST helpful forum that I have been a part of and I want to say thank you. The tips, tricks and helpful advice that you all contribute to have been lifesavers in many instances. I can only hope that my knowledge will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.