Search results

Thank You so much CJ_London for all your time and input. I have been reading up on sub-queries and will approch that route to do the calculation of "TimeDff". Regards, boaterjohn

CJ_London, attached is my very small access database. Feel free to see exactly what I'm trying to do. I think I might have misled you in how I discribed what I was after. Thanks Much, boaterjohn

Thanks CJ_London, I'm a little green in queries and have never used a sub-query, but have used sub-forms. My issue is this, I have a form with only the 5 fields as you saw in my original post. At the end of the day, I enter 15 to 20 records in the form; filling in the first 4 fields. The last...

CJ_London, Thank you much for your time and qry. The 1st one that will give you the difference between the timestopped of the current record and the previous record is the one I need. However, did you use just one query and if so, how did set the qry up to preform the calculation? boaterjohn

Thank You Kindly thechazm. I will have to digest this tomarrow and will let you know how I make out. pbaldy gave a nice link as you said. I checked it and it seemed to go on date links of the database which gave 2 readings on different dates. This would have been great; but, as you can see in my...

This TimeDifference Calculation will be done on a daily basis at 18:00. The next day, a new query will be made using the daily date only to extract the times for that day. As you can see in my table, I need code to loop thur the daily records for that day. The query will sort the CarNo and...

I have a query that has 4 fields.- " Date, CarNo, TimeStopped and TimeDifference. The query is filtered useing the "[Enter Date]. The "TimeStoped" field and the "TimeDiff" field are short time format. An example of what my select qry looks like: RecNo Date CarNo TimeStopped...

It worked like a charm. Thanx for your help for this code. Boaterjohn

I have a access table called Fruits. I have 2 fields in this table: fld 1 = "Fruit" fld 2 = "LName" fld 3 = "Fruit Code" Using the following Below: When I enter "Fruit" field, it stays blank. It should show "Grapes". I'm obviously missing something in this code. Any help, appreciated...

Greetings All, I'm just really starting to code in vba. It is very chalenging and keeps my brain fine tuned. Looking foward to meeting new people and learning much more. I'm 68 yrs old and retired. I live in USA near Phila., Pa. All, Have a great Day.