Search results

Exactly!! I am so excited to use this the next time I need to pivot my data. :) I don't know why this solution hasn't popped up in my previous searches to make this process easier. Thank you much!

So we agree on what I want to end up with...

site 1 parameter1 flag value site 1 parameter2 flag value site 1 parameter3 flag value ... site 1 parameter40 flag value site2 parameter1 flag value INTO parameter 1 parameter 2 parameter 3 flag value flag value flag value ...

Thanks all! To answer a few questions, I have no idea how to use crosstabs so pivot tables is what I mean. Imagine one site with 20 parameters and results listed in one column, followed by a second site with 20 parameters (maybe not the same) and results listed, etc. Basically, I need to take...

Yes it was. Turns out I should have been using a combo box instead of value list. I can't believe how hung up one can get on such a silly little misunderstanding. Gosh...

I created a form with subforms that are all linked to their own tables. Values that are entered in to the form (i.e. just numbers or names) all save into the tables as I would expect; HOWEVER, all of my value lists (0,1,2 or 1-5) do not. I can change the values in the forms and as long as I am...

My issue is always that I want to pivot water quality data and its flag values. I don't want calculations or summaries or anything. What is likely is that I need to learning some coding to do the things I need sometimes. Can anyone suggest an online instructional series on VBA that may be...

I imported the data from excel to access, pivoted it in access because it can retain the value but then want to send it back to excel for analysis. If I pivot this in excel, I can't get the values to show up...if you know how to do that it would change my life. :)

Hi All, I am so frustrated trying to export my Access pivot table to excel because every time I do, the values (which are text and numbers; i.e. some numbers and some <0.05 format) are changed into a sum, product, blah blah blah. I need to rearrange this data not calculate anything. Does...

Everything seems to have worked out fine. I had a few kinks to work out but the database and forms are made and look great! Just some trial entries to do. Thanks Minty and Simon MT for your help. Much appreciated. Not quite sure how to end the thread but my problem is solved! Lou-Lou-Bell

Thank you for your responses! I have one parent form with 8 tabs (subforms) that link to 8 separate tables. Eventually, I will be adding two more tables of lab data which require no entry, they are all going to be linked by the sampleID. The ultimate goal is to be able to query out whatever...

Thank you! Yes, I started with subforms and did link them using the SampleID. One more quick question, do I have to have the SampleID re-entered on each tab (which represents each table) or will filling it in on the first tab populate it in all the linked tables? Thanks so much! PS I think...

I noticed at the bottom of the screen after I posted some suggested posts...I read one on solving this by creating subforms. I'll read up on that until I hear from someone. Thanks again!

Hello, Somewhat new to Access, I am creating a database in which to store my data collected in my research. I have 8 tables that are linked by a SampleID number. I have created a form which has tabs, the first tab contains the information required for entry on table 1; however, I am now...

Hi, My name is Lou. I am a graduate student that is slugging along trying to find the most efficient and accurate way to store my data. I use many programs including access, excel, ArcMap, and several statistical programs; however, I am not a master of any of them! I do some simple functions...