Search results

Hello, I am trying to figure out the best way to start a db to track points. Basically my data consists of Clock number Employee name in one table and Observer points is worth 2 points Observee points is work 1 point Tool box talks are worth 3 points LOTO is worth 2 points I am not...

thanks I will give it a shot

I have a db that is quite large, and since I am new"er" at using access, I'm sure I didn't design it in the most efficient way. My db has grown so large in fact that after a few operations it starts having a nervous breakdown and says "cannon open any more databases". (or whatever the message...

JHB, I want to try to minimize the amount of the queries under MTFB. My db points to the attached xls file which I why I attached it.

Hello All, I have this database that is getting rather large. And by large I mean lots and lots of queries. I already compact the DB on close, but I was hoping someone could help me condense the number of queries I have to use to get the same information. Please look at the MTFB queries...

Thanks guys, It was much more involved. I ended up having to build lots of other queries to get my end result.

by not working I mean it returns nothing in the query. There are 22 records in the query and what I want is to calculate the number of days between the first and last dates.

Hello All, I am having a problem with a datediff expression. I have a query that pulls the first date and the last date out of a list but are put in seperate fields. I thought I could build an expression for datediff to calculate the number of dates between them. I can't just put in the...

Hello everyone, I tried to apply "compact on close" and I get the following message/error. The Microsoft Office Access database engine cannot change the design of M:\416.accdb. The minimum required version to change the design is 41.0.0000.0000. What does this mean and how do I fix it...

Hello All, My name is Angelina and I'm a new memeber. I use Access mostly for work, but I really get into my Access projects and usually end up taking them home with me. I'm fairly new to programming, so please...dumb it down a bit for me. Anyway I look forward to getting some answers and...