Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Thursday, September 27, 2018 4:50:48 PM(UTC)
Rank: Newbie


Groups: Registered
Posts: 1

Hi, we have an ESdat Access dataset with a large number of samples (i.e. Field IDs) and Chem Groups.  Due to the restriction on number of columns we cant output all data in a single table. 

I have outputted several tables for several different Chem Groups but am unable to combine the tables easily as the Field IDs do not line up (i.e. not all samples/Field IDs have same chem groups).

Is there a way to output all Field IDs including blank/null values for the specific Chem Groups? This way all the rows will line up in the tables we generate.

Hope this makes sense.



Warwick Wood  
#2 Posted : Wednesday, October 03, 2018 8:08:50 PM(UTC)
Warwick Wood
Rank: Administration


Groups: Registered, Administrators
Posts: 406
Location: Byron Bay

Was thanked: 8 time(s) in 8 post(s)

Hi Justin,

Sorry there is no magic answer, Access databases have their limitations.  If you want to produce very large tables you would need to look at the Server version of ESdat.


Similar Topics
Field and Lab data output in seperate columns (ESDAT)
by Babs 2/18/2012 1:58:04 AM(UTC)
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.