Search results

Can I embed the above inside a macro arne?

So it's proving Gasman :) So avoid any confusion with my generic statements above the SQL for the Query that works and pulls the values I wan't out of the table is SELECT [Physics QC CTDI Refs].[Low CF], [Physics QC CTDI Refs].[High CF] FROM [Physics QC CTDI Refs] WHERE ((([Physics QC CTDI...

unfortunately that doesn't seem to work either, how difficult can this be :)

Thanks DBguy I thought that too tried a few variations on the following DLookup("[myValue]", "[myTable]","[Criteria1]=Form![Value1]" AND "[Criteria2]=[Form]![Criteria2]") But no joy query seems to run ok but doens't populate the box on the form with the correct data my table is in the format...

Good morning all I have a database I look after that I inherited sometime ago from the original creator who is no longer available for advice recently a user has asked for a modification to said database that necessitates a modification to an existing DLookup statement to add a second...

Good Morning all I've inherited a database that tracks maintenance records of a number of machines, breakdowns services etc Currently we have no means of recording whether a "job" is still live or not as each machine visit is recorded as a seperate record and is treated as closed after...

My apologies for the tardiness of the reply right I changed the DATE field to LastDone but still had problems, I'd tried to recycle some of the old formatting but for what ever reason that didn't seem to work with the new I solved the problem by using the same rule as described in my first...

Right Made another field in the relevant query for the report and Mapped [DATE] to it as LastDone: [Date] this essentially compies the date field to the LastDone field I then pointed the DATE control on the report to LastDone and change the conditional formatting to reflect this sadly it still...

Thanks for the Reply CJ The Date field is something I'm going to have to live with I inherited the database and it's used all over the place I also understand the 121 day problem I can fix that fairly easily I think, however the cross over between green and red seems to be at 96 days for...

Good Morning all I have a quick question about formatting a filed in an access 2010 report? Firstly I thought there was a limit of 3 rules on conditional formatting I tried to add additional rules and there seems to be no problem doing that. And they all fire with varying degrees of...