I am wondering how I could specify the source of the database so this, perhaps as a global statement, could be referred by each dt=. As you could see in the the following script, to get data from multiple Access tables I duplicate DBQ=.... for each dt=. The only difference is the "SELECT..." part. In SAS, I would write a macro variable (%let dir=E:\Now\(Project) RFID_r3_Homing_r1\Ben analysis\) to specify the location of the database. But I haven't learned how to do the similar in JMP. I have underlined the duplicated part of the first two dt=. My script is attached.