ESdat Forums
»
Forums
»
ESdat
»
Customizing output
 Rank: Member
Groups: Registered
Posts: 14
Location: Vancouver
|
Hi, I am trying to add a couple of columns of data to the Chemistry Output Table list of Location/Sample Data. I've opened the database in Access to modify the query SChem1_Chemistry and from what I can discern, in order to get what I want to appear in the pop-up, the fields that I want have to come from another query that is imbedded in the SChem1_Chemistry query. This is called samp_SampleLithology. I can see this query listed when I look for it in ESdat, but when I use Access, the query is not there. What I want to do is add three more choices to the Location/Sample Data field - Lab_SampleID, Extraction_Date and Analyzed_Date. Can you offer any instruction? Thanks Tom
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hi Tom, You wont be able to output Analyzed or Extracted date/time as that is stored at the Result level, and wont necessarily be consistent for all results for a sample. Therefore it cant be included in the ChemTable style output with samples on one axis and compounds on the other. The QAreport has a holding times output tbat may be of use? Warwick
|
|
|
|
|
|
Rank: Member
Groups: Registered
Posts: 14
Location: Vancouver
|
Thanks Warwick. We will try using that approach. Tom
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Customizing output
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.