Recent content by GJT

Try the attachment below : edu.db I have created some similar tables to those decirbed and two querys using an aggregate 'min' function on the educational ranking index to return the 'highest' educational attribute per person. Runnig Query2 returns each person with their highest qualification...

Sub form / report - either should work but to no avail. I think the problem is that I am trying to generate an average from the TOP 10 values 'on-the-fly'. Maybe this cannot be done easily...???? I had thought of doing a table that is generated every once in a while that contains all sizes and...

I have a report schedule that displays various information for our production dept. The underlying query for this report returns a number of fields from a handful of tables. I now need to add an additional couple of fields to this report that will detail the appoximate time to complete the job...

Jon With your help - my determination and a lot of tweaking (and hair pulling!), I have eventually got a 5 stage query structure returning the dataset I need! Thanks for your assistance.

Right - next thing! I have user level security in place on my OS, I have created a new / smaller DB with the tables in question but you will also need the MDW file along with user name/password to access the file. I would rather create a DB file only, any ideas how I can temporarily disable this...

Mailman Could you possibly post the link in 97 format please? Some of us are rather behind the times .....!!!!! I have read some of the other postings here - namely http://www.access-programmers.co.uk/forums/showthread.php?threadid=57085 , but this example seems to have all content in one...

Rich Ok - I was wrong - but I have just discovered that it is not just most recent record - it is the two most recent records per machine! Now do we have to use the TOP predicate and if so how???? Thanks

Rich No-can-do. This table will grow substantially over time. Grouping still returns ALL records in the table - I only want the most recent item for each machine i.e. 10 machines - 10 records/1 per mc . I think this can only be achieved using the 'TOP' predicate - though quite how; I'm not too...

Please help - cant seem to get this query right. Basically, I have two tables : one table containing time stamped log entries for 10 machines, the other table contains staff identifiers. When a user uses that machine, a log entry is filed in the machines table where with the user id as the key...

For the sake of example/clarity here follows a much simplified version of a crucial reporting function on my DB….. I have a contracts table represented by the fields : Contract No. / Size / Qty I also have an assembly parameters table represented by fields : Machine No. / Size / Param1 /...

What type is the field in question? Is it a memo field......??????

Hi Chaps/Chapesses i have a report that presently incorporates an embedded Excel OLE object. The Excel detail is simply a set of boxes/text, used as a template for handwritten entry when the report is printed off. However, I now wish to populate the cells in this Excel OLE control at runtime...

I wouldn't put any code in the AfterUpdate() event of the check box - leave any validation to the Form_Update event or Form_Close. What are you doing in the Update() event?

No problem people - have used DLookup - which does the job nicely!

Any ideas on how I can present this data in an appropriate format on the form or any other way ? Messagebox perhaps but this is not really ideal as each individual record would need to be interrogated one at a time....????? Any ideas?