Recent content by Hunter J.

Thanks Jon K. The query still returns the same time for all four TagIndex. Thanks for the help. Hunter J.

I have attached a zip of a test data base. I am trying to get the last date and time associated with Tagindex 19, 38, 22 and 29 8/30/2004 09:27:59 19 8/30/2004 09:28:29 38 8/30/2004 09:28:59 22 8/30/2004 10:39:04 29 Any help is welcome Hunter J.

Is it advisable to run 39 queries and then bring them together in another query so that I can include them on one report? This question arises from another topic that I have in the general topics area that I should have started in here. Sorry about that. Thanks in Advance, Hunter J. Novice at...

Sorry it took so long to get back. Let see if I can explain what I am trying to do. I have created two tables that data is automatically logged into by a PLC. One table is for the current product that my equipment is running and this data is start/stop date and time. In the other table I log...

Hello, I could use some advice if at all possible. I have created a database that will report production information off a specific machine on the production floor. Here are some my questions/concerns: 1. I have the potential to log 400k records a day. Most of them are bits 1 or 0, but that...

Update. It worked great. My problem was I was inserting "=" when it should have been "<" like FoFo, Pat and pbaldy poined out. This site is great because of the people helping here. Thanks Again. Hunter J

I can't test again until Thrusday but I will look into the name "date" to see if its causing problems. Thanks for all the help. Hunter J.

DELETE [040709AF].*, [040709AF].Date FROM 040709AF WHERE ((([040709AF].Date)=DateAdd("d",-3,Date()))); Hope this is what you are asking for. Sorry, I am very new to this. Thanks, Hunter J.

I am still getting all the records using..... DateAdd("d",-3,Date()) I am using the day to test with since at this time I don't have 3 months of data...I am trying to plan ahead. Again, Thanks for all the help and understanding. Hunter J.

Both ways give me the whole table to delete... Thanks, Hunter J

I am working on a delete query to delete data from one table. I want to delete the data that is greater then 3 months. How would I type this in the criteria? Thanks for any help. Hunter J.

Thank you. Worked like a charm. Hunter J.

How do I get a calendar in a form to show the current date instead of the date that it was installed into the form? I have tried place "now" in the value box in properties but it doesn't highlite the current date on the calendar? Thanks for any help. Hunter J.

Thank you. I will give that a try. Hunter J.

Is it possible to run multiple querys from one command button and if so how? Thanks for any help. Hunter J.