Recent content by tripptofer

Much obliged trevor- very much looking forward to learning and finally getting some traction on this as I know that a whole new world will open up. Thanks again, tripp eltryptophan@gmail.com

Trevor- Well spotted! It was indeed and I am trying to move in that direction for another project. I know a bit of excel (enough for my purposes, but obviously trying to get better) and very little of access (originally a mac lad and thus only recently shifted to pc b/c of this). On the...

Trevor- I appreciate your response. I too am uncertain if a pivot table is the proper way of addressing my needs, and would have in the past devised umpteen formulas to calculate what it is that I sought. I was assuming that there was a better way using pivot tables, however their...

I'm grateful for kind assistance and agree that the dbl y cols. aren't pretty. Thank you for this- I'm now itching to contact the reviewers to see what exactly they had in mind with their comment... Cheers!

Hiya- I'm trying to get my head around calc. fields and items as I am certain it would make my life easier. Attached is a book with data and a mock pivot table. I would like to be able to add a chitest column comparing males and females (data present in table), but would also like to know how...

Can you believe this was my attempt to address a reviewer's comment for a journal paper? I thought 2 lines would be fine- something to do with continuous variables, which I thought time was. Apart from aesthetics, is there a way to fix this problem apart from the workaround of setting up dummy...

Ok- I had another stab at it. I was originally trying from scratch and after reading your reply, I converted a line graph that worked into columns. Either way however, it would seem that excel is hiding one of the series- even after tweaking the gap/overlap. Not sure if this is an excel...

Hiya- I just learned that you can have a 2nd y-axis on a column chart, which I am told is more appropriate for categorical data than a line chart. Problem is that I only seem to be able to put 2 columns of data on the secondary ordinate- there seems to be a limit of 2 (when I try and put the...

Okie, I've now had a few days to digest all of the input and suggestions from last week and have been trolling the net for analogous examples of trying to JOIN two tables using OR statements so that I can "backill/correct" entries from a master table imported from excel; attached are the...

DocMan, dportas, gemma- Thank you all for your guidance and insightful advice... I think I am still a bit vague on candidate keys- not so much on what they are in theoretical terms (I get the lowest number of attributes that makes them uniquely id any row in a table), but in getting them set...

This is all gold- thank you all... I shall take another crack at teasing out the various bits into more sensible groups of buckets and have already changed the CURRENCY to CURRENCY_ID, which is when I then realised that the data in that attribute wasn't an international standard as I'd assumed...

Thank you for this Doc Man! I've now rejigged my overall design (attached, pg 3) taking on board all of your comments and standardizing my notation (and naming, which I hadn't realised was still so sloppy!). I've tried to split out all repetitive data into their own subtables and then add FKs...

I've posted here before and thought I made some progress, but it would seem that there is still something very fundamental that I am simply "not getting". I have tried to use the examples in the Access2003 bible and even the results of Analyze table to automatically see how Access wants to do...

Oops! Grabbed the wrong screen by mistook. Sorry 'bout that...

Okay, I've made significant progress thanks to a kind academic. It turns out that you cannot simply make a table object the way I thought you could- it requires running a make-table-query, which in hindsight makes sense (running an sql script). One of those niggling details that is so small...