Search results

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...

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...

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...

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...

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...

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...