Search results for query: *

You are right lbass, I thought you were talking about a SQL in a command (table)! My mistake. Your command works, thanks for that but this is not a good solution for me, due to my question I guess. The solution however is more simple. I made the following Command: Select EquipmentID...

Thanks lbass for your quick reply, but ... When I use this SQL Expression in a Command (Table), I get the error: "The column prefix 'vJobSce' does not match with a table name or alias name used in the query." For my Chart I need the two dates: StartDate and Max(StartDate) When I try another...

Hello, I have a table (in fact a view) with Jobs for Equipment. Every Equipment can have several Jobs. The fields of concern are: - EquipmentID - StartDate In a Numeric Axis Chart I want for the x-axis the different years in StartDate: so the field is placed in "On change of" and Order: per...

Suppose your records have a unique Serial_Number. First define a global (number): gSerial_Number. Define a self relationship based upon the fields gSerial_Number and Serial_Number. Two scripts are then needed: 1. Remember the current record: Set field[gSerial_Number, Serial_Number] To return...

SecureFM is a plugin from http://www.newmillennium.com that manipulates the FM menu. Hope this helps. Dani