Search results for query: *

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

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

I have a query that we use in Access 97 and upgraded to Access 2003 and works fine. Now we want to run them using a SQL database but an Access 2003 frontend. When I open the new query in Access 2003 it takes close to an hour to run but when I run the same query in the Access 2003 database, it...

I am retrieving a Timestamp date that has been saved in the database but the format doesn't have leading 0's and I need them to sort the date field correctly. However it also has the /'s and the minutes in the format. How can I do this?

I have a program where the user can create a folder name but when it is in alphabetical order and there is a number in it, it doesn't sort in the right order: Folder Name 1 Folder Name 22 Folder Name 4 New Folder 1 New Folder 2 If the prefix was always the same I could do it but since they can...

I need to concatenate a value for each time it goes through the loop. This loop is used to pass the values to the database and that part works (the Call AddEquipUsers) but then I want to take the "sEquipUserName" and create a list that is comma deliminated. I'm going to pass it into a new...

I want to retrieve the data from a database and put it in a table but I need to use a nested loop. I think my code is close and I know I've done it before but I can't that code any where. I want it to look like this: Folder 1 File 1 File 4 Folder 2 File 3 File 7 Folder 3 File 5...