Search results for query: *

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?

My question is how do I make it so that the Mid, Right, and Left functions work in 2000 not what do they do.

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.

Thank you- I will try that

No the field is just one- service date. After a caseworker works with the clients it is entered in the database for billing purposes. This is a new report they have requested- So all they have needed to enter was Client #- Date of Service-Hours- and Travel

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

The tables are exactly the same. If I create a "back end" database will it allow me to add additional tables unrelated to the other two (employee info. etc)? The Admin. database is necessary to bring all clients together because it needs to then link to the billing database. The...

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

Thank you Cornerstone....we are up and running great now!

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

Thank you so much!!  That is exactly what I needed and it works perfect.  I wish I had gotten on this forum and asked this question about 2 weeks ago- it would have saved me many headaches.

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 8 expressions in a query that need 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).