Recent content by d222222

Thanks markros. I tried that and it worked too. You're right, I could have caught that if I'd looked at it closer. And you didn't make me feel like I was being yelled at.

Thank you so much gmmastros!! It worked!!!!!! Thank you sooooooo much. I found some code on the internet that said to use an Inner Join but I still couldn't get it right. Thanks for your help!!!

To bborissov I was NOT trying to code it according to just one row being affected. I was trying to explain that I think that's what my code was doing but NOT what I wanted. All I wanted it to do is update the count in the rm table after ANY change is made to the em table. I tried your code...

Thank you for your response. I tried it and got an error message that says that the rm.bl_id, rm.fl_id & rm.rm_id could not be bound. It might also be because of the code at the top of the trigger that references the em table. This is what I tried: ALTER TRIGGER [afm].[employee_update]...

We have a field in the rm (room) table that counts how many employees occupy the room according to the em (employee) table. We want to create a trigger to update the rm.count_em field when a change is made to the em (employee) table. It also uses the bl (building) field, fl (floor) field to...

I hope this will make sense. I'll do the best I can to explain what I'm trying to do. I have a report that is not returning the results the way I want it to. This is how I want it to display: Site Code Site Name SENIOR_CTR Senior Center Property Code Property...

We are using Archibus Web Central. I got it working. I don't know if it was the SQL statement changes or the changes to the other code but all of a sudden it works. Thank you for your efforts.

Unfortunately I can't do either one because it is being done in an existing application that already had the tables created. Making changes to the table would be a nightmare. I agree that it would be a lot better if the names were better but I don't have any choice in the matter. We also...

I have several fields in multiple tables that have the same name so I have to use alias's. I have changed the code so many times and keep getting errors either from the alias's, the grouping or the key fields. This is the latest code: SELECT rmpctsum.bl_id, rmpctsum.dv_id, bl.bl_id...

I've been playing with it and now I get it to read the date but it's not quite right. I'm using an alert popup box so that I can see the date the it is using. Here is the code: var myDate = new Date(); myDate.setDate(myDate.getDate()-160); var myNewDate =...

I have a date that is in a form that is retrieved from the database and I need to check the date and see if it is more than 6 months old and if it is, make the row red. However the only way I can get it to work is if I use "innerHTML" and hardcode the date. I'm trying to find the code that...

Thank you for all of the references. I will read up on everything. I added a "right join" and that's what got it to work. No wonder it didn't work if it was doing a cross join and creating so many records. I made a mistake in my original post. It didn't work in Access 2003 but it worked...

Thanks for everyone's help. I am new at using Access and trying to run it through SQL is definitely challenging. I will definitely take all of your advice into consideration. After seeing qmmastros comment about the JOIN I decided to try adding the JOIN back in that was once there and it...

Since it works without the GROUP BY I was wondering how to get it to work with it.

No, it's not working since I changed the DISTINCTROW to DISTINCT. I still have the problem. I have form fields in other queries and they work OK so that's not the problem. I will look and see if any of them are using IIF. Looking at the history of the query there was a JOIN at one time but...