I converted an Access 95 database to 2000 and now I get the error message:
Run- Time Error '3085'
Undefined Function Mid in expression
The Left and Right functions do not work either.
How do I make these functions work again?
I converted an Access 95 database to 2000 and now I get the error message:
Run- Time Error '3085'
Undefined Function Mid in expression
The Left and Right functions do not work either.
I need to create a report for our finance office and they need the data in a specific format. The report is done biweekly for services provided and the total cost. The catch is that for a two week period a client could have multiple dates of service and they want the data in this format...
I have two databases that two different people are entering data into. One database for adult clients and one for child clients. The third database is the Admin. database where all data from the other two databases needs to be imported into for billing. I have created the links in the Admin...
We are currenly using Access 95 at our office (I know!) and we could use some assistance on a query we are trying to create. We need to create a query from our date of birth field that will allow us to view only our clients 65 or older. We have made several attempts using...
I have a database at work with one of the forms being where the client data entry is done. Up until about a month ago when you entered a new case the SS# stayed in that field when you entered a new record and stayed in the field until you changed it. This saved quite a bit...
Really need help! This must be a tough one because I cannot get the answer anywhere. I need 8 expressions in a query to round to the nearest 50 cents.
I have created a database and the final 8 expressions in the database need to round to the nearest fifty cents (I created all the calculated expressions in a query to determine client income eligibilty).
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.