Recent content by groul

Hello PHV, Thank you very much, it works just great. Ulli

Hello, In a Form I got a field named "Costs". The figure I enter is the cost paid for something and includes the VAT. I want to show in a second field the costs without the VAT. Sofar no problem (for a fixed VAT figure I use "=[cost]/106*100" in case of a VAT of 6%), but the VAT might differ...

Hello bcastner, Even I have not been in a position to solve the problem as of yet, I like to thank you for your time. It seems to be there are more problems (Word/Excell/Access97 cannot be opened anymore, Access 2000, yes). I shall spent some time at the weekend to start from scratch one -...

Hello "bcastner", The camera ist not listed in the device manager, propably because it will be attached to the PC by means of an USB cable. However, everything worked fine prior installation of SP4. Repeated installation of the USB-driver (included in the FinePixViewer-Software) did not solve...

Hello, after installation of SP4 I still may open FinePixViewer for Camera Fuji S304. The first couple of fotos are loaded but then FinePixViewer freezing. No chance to work at all anymore. The application FinePixViewer can only be switched off when switching off the camera itself. Any hints...

Duane, I decided to keep the structure of the SQL with "[Which Date]". This way one may produce a previous report (e.g.for comparision, if wanted). Thank you very much for your help Ulli

I probably did not express myself good enough. What I meant is that it works fine for any report, for which I use the relevant listed revision date. Not quite sure whether I understand your question concerning the book and manual, but both can be seen, like all other required fields in the report.

If I remove this:"=(Select Max(Rev_History.Date) from Rev_History)", or "=(Select Max(Rev_History.Date) from Rev_History rh WHERE rh.Ref = Rev_History.Ref)" and replace it with a fixed - existing - date, it works fine for a particular report. It works fine also for any report, if I replace above...

Yes, I do realize this, in fact this is what I want. One date (and its relevant revision number) only. The report is suppsed to show all shops, for which I got: (Shop1.Cap_List)=-1) and one revision/date only - the latest one. Using your last proposal, the report generates the same problem as...

Duane, It now looks like as foll in the SQL View: SELECT DISTINCTROW Lib1.MANUAL, Lib1.BOOK, Lib1.TITLE, Lib1.PARTNB, Lib1.TYPE, Lib1.ATA, Lib1.VENDOR, Lib1.[LAST AUDIT], Lib1.REMARKS, Lib1.Dash, Lib1.Last_T_R, Lib1.T_R_Date, Lib1.ShouldRev, Lib1.VENDOR1, Lib1.Series, Lib1.PreparedBy...

Hello Duane, If I remove this:"AND ((Rev_History.Date)=(Select Max(Rev_History.Date)from Rev_History)))", the report generates all required fields/records. Except if more then one record exists in the table "Rev_History" for a particular Manual, the report generates multiple records of fields...

Hello hneal (hopefully it's you who is reading this), using part of your solution from my previous problem for another report, I am stuck again. Following is the contents of the "Select Query":SELECT DISTINCTROW Lib1.MANUAL, Lib1.BOOK, Lib1.TITLE, Lib1.PARTNB, Lib1.TYPE, Lib1.ATA, Lib1.VENDOR...

Hello hneal, This makes sense. It works! Thank you so much. Ulli

Actually your last code does not include the field "Rev", that is why I added "h1.Rev". I copied your code and pasted it into the Query Builder (SQL View), the table name "Rev-History" changes then to "h1". The Control Source for the field names "Rev" and "Date" are coming then from table "h1"...

Hello hneal, It is really kind of you to spend such a lot of time, however, the last solution doesn't work either. I added to "SELECT DISTINCT" h1.Rev. However it still does not work. As soon as I try to generate the report, following appears: Enter Parameter Value h2.Date.Text and thereafter...