Search results

You have the patience of a saint and it is appreciated. How do I tie this check box on the form to this field? Thanks

Nope that still appends all my records but I appreciate your responses.

Sorry where do I include or find the close event part you mention. Thanks.

Thanks for taking the time to look at my problem first of all. I have a form that shows records but I want a button next to each record that will append that one single record to another table that is built exactly the same, which is for historic records. Not the brightest on Access and I can...

Dear rob and max, my form is now fully functional and the number of days is showing beautifully! Thanks for your help, the frustration has now disappeared! Have a wonderful christmas and all the best for the new year Steve

Thanks robthedog, see me last bit though, any ideas on getting the query to display on the form for each record. At the moment my query works but just displays a list of all records with the days elapsed next to it? Cheers Steve

Firstly many many thanks for your replies. The problem is I am access challenged. The form, based on a table exists. Using the search you kindly recommended earlier I have now developed a query that works but how do i get the results for each record to show on the form?

More to this I need the field in my table so I can place it on a form. How do I make this calculation in the table.

Hi. I have compiled an access database (office xp) and two of the fields are start date for a task and end date of a task. I have been asked to set up a field that calculates how much time has elapsed since the task began and once complete how long it actually took from beginning to end. Can...