Recent content by Gunit

I kinda figured I would get this answer. I was hoping someone might have a creative way of doing this without having to construct code.

Was wondering if someone could help me with finding the easiest way to join 8 different tables by a common field and finding unique records in each that aren't in any of the other 7 tables. Anyone know of an easy way to do this?

Thanks Ken - Your help has been much appreciated.

Thanks Ken - That took care of the overflow error and the form works wonderfully. However when I try to use the function through a query, it returns a "0" value. My record count = 4102 and the highest numeric string = 6 integers. Any ideas?

Sorry Ken. I wasn't paying attention. Okay. This will work but I'm getting an overflow error off of this statement....f_getMedian = (intNumOne + intNumTwo) / 2...when trying to use function. Any ideas?

Please see attached. I need for access to calculate median as excel does. I need the median of the values within a range...not the middle value within a range. I would prefer to have a function that would call the values from a column and display. I'm sorry I've been so difficult to understand.

Ken - I've posted a sample of my project to get a better idea of what I'm doing.

That would be great Ken. I am leaving for the day though. I will post details tomorrow morning.

Yes. For calculating vertical data in a form however I want to know if you can call it from query design rather than from a form. I have criteria in query design that I want to be true and from those results, I want to find the median of a data column.

I'm already calculating the average. But average and median return different things. The median calculates the 50th percentile. So basically, I need to know the middle wage. Access has built in functions. By totaling, it will avg sum min max ......etc. By turning on the excel obj...

Thanks for the link. I need to calculate the median based on 4 different criteria specs. Age range Gender Race Degree I want to find the median of wages for any combination of the four above. The column named [wages] looks like this in query design view: Expr1: Avg([WgTtl]/100*4). So I'm...

Yes but I'm only a beginner at Access. I used some VBA code off of Microsofts support sites but couldn't get it to work in a standard query.

Could someone please help me? There is no function in Access 2000 to compute the median of a column of numbers (Currency) from a table.

I have a subform within a form when run will not display. In design view however, I see all the fields from the subform...and all links appear to be fine. Any ideas on what the problem might be?

Im not too fond of lookup either but I went ahead and designed it that way. Thanks!