Search results

Thanks for this. Sorry for the delay in replying, I've not worked on the database until now. My department thinks I can do the work of three people so something had to give! Thanks for your help! Dave

I hope someone can help me with this. I have a parameter query that asks the user what category they want to search on and then prompts them for two dates. The query then displays the amount of working hours elapsed between the two dates (thanks muchly for the advice given here earlier!). The...

Cheers, thanks for that, I've found what I need. Was panicking yesterday and not thinking clearly!

I hope someone can help me with this query. Our admin team have a database where they store all requests (stationery orders etc). Dependant on the request, they have a certain amount of time in which to complete it. It could be 24 hours, 5 working hours, 1 working hour etc. The times and...

Cheers for that, that was just the job! Dave

I hope someone can help as I am stumped at present. I have created a calculated query using dateadd. I have a table that has date fields, ServiceContractAgreed and ServiceFrequency. The service frequency field holds a value of 3,6,9 or 12 in months. Using dateadd I can add the months to the...

Thanks very much. Just what I wanted. Cheers for that!

Thanks but the data is in multiple tables and the find duplicates query only lets you select from one table. I need to browse through all the tables and find how far back clients go. No-one thought to include a date created field in the client table! Any ideas? Thanks

Hello I've had to export data from an old third party database to Access with the task of reporting on the data. I have a client table and work tables, one for each year going back to 1992. In the original database, the clients do not have a date of when they were set up. I need to find out...

Apologies for the late reply but I have been away. Yes, the relationship was the problem, and I have amended. Many Thanks for your help! Dave

Hopefully someone can help me this (and hopefully the solution isn't staring me in the face) I am trying to export data from a cell in a worksheet to a field in an Access database that I am building. The database has two tables, tblCompanies and tblQuotes. It works through a macro accessed...

Hopefully someone can help me this (and hopefully the solution isn't staring me in the face) I am trying to export data from a cell in a worksheet to a field in an Access database that I am building. The database has two tables, tblCompanies and tblQuotes. It works through a macro accessed by...

I have a form that amongst other fields contains a DateOfCalibration field, a CalibrationInterval field and a DateOfNextCalibration field. The DateOfNextCalibration field contents depends on the value that is in the drop down box in the CalibrationInterval field (in months). Is it possible to...

Thanks, that's excellent. Just what I need. Cheers!

Hello I am using the DateAdd function in a calculated text box. It gets it's data from a combo box. The data looks like this: =DateAdd("m",[CalibrationInterval],[DateofCalibration]) All works well unless there is no date in the DateofCalibration field. Can I use the NZ function within the...

I'm working on a database where the user has to enter a date in a field called DateofCalibration. The next field (CalibrationInterval) needs to be a drop down list detailing timescales ranging from 6 months to ten years. On entering a timescale, the DateofNextCalibration field will...