Search results for query: *

Thanks dhookom, Simple for some, harder for others.

dhookom, The names would be in a table. I am trying to match them to a teacher in their area. The teacher names and zip code would also be in a table. Sorry for not being clearer.

I am trying to match people according to their zip code. I want to input their names in a form and it would automatically put them in a group with others that match their zip code. Any suggestions would help. Thanks

Thank you, it worked!

I want to delete all document history in word 2007, I have a particular document that is linked to a web page that can be opened by any user of word. This is a problem.

Thanks dhookom, I am going to try to do it in the form version. pops49

dhookom, I am trying to sum values coming from a plc on a hourly basis. I would like a running sum of the hourly data e.g. after hr #1 + hr #2 + hr.... I can put this on a form and at any given moment the total sum of the hourly data can be seen. Thanking you in Advance.

Thanks dhookom it works!

dhookom I am still having problems,where do I insert the formula that you suggested. "timevalue(dateadd("h",8,[hourfld]/24)?

dhookom every morning at 8am I must read a sum of the last 24hrs. The records that I sent were snapshots of the hourly data. Whatever the total is for 8am -8am will be divided by 24. I hope this helps. Thanking you In Advance. pops

dhookom, This is some of the records, I made sure the times were included. 8am-8am is what I need. Thanks DateFld HourFld Sum Of FI_F6002 1/13/2007 0 10.97 1/13/2007 1 12.12 1/13/2007 2 13.97 1/13/2007 3 15.74 1/13/2007 4 15.94 1/13/2007 5 16.19 1/13/2007 6 17.68 1/13/2007 7 20.84 1/13/2007 8...

Thanks dhookom for the last response, but it didnt work. I replied on the 18th, but I dont see it here. I'll try to send the records again. (cant copy small amount of data, it is taking the whole database) suggestions? Thanks

This is a date/time data field coming from a plc, is it possible to change it in a query? When I give it multiple dates it works fine, but when I give it a range for times (24hrs)(8am-8am) instead of midnight to midnight it will not work. I will try to send you an example on 1/18/07 Thanks pops

I have a query from a table with "hour" for one of the fields. The problem that I am having is the "hour' field is in military time. 0=12 midnight and so on. what I would like to do is make "0"=8am. Is this possible. Thanking you in advance. Pops49

I would like to view only the last 12 records in a subform. Is this possible, I would also like to use a command button to call the subform. Thanks in advance