Search results

Thanks Gizmo, I'll go try that out.

Is it possible to print two records on one label? I have to print 200 numbers onto labels for ID purposes and I don't want to waste 200 labels if I can use 100. For example, I need the first label to be: BACKNUMBER BACKNUMBER 1 2 and the second label to be...

Holger, thanks again for your help, I really do appreciate it. I was toying around with the idea of concatenating but I really didn't want to. I guess that would be the easiest solution. Thanks again for the help.

Holger, wow. That works almost perfectly. There is just one slight problem, there a few father and sons in the data, who are in different divisions. Is there anyway to modify that code so that it looks at both "Last Name" and "First Name" columns? I've attached a new data file that has both...

Thanks for the reply shades.:cool: I've attached a copy of the data with last names and addresses removed. The first sheet, which is named "All', has all the people in it. The following 4 sheets have the people in the correct sheet (sorted by division). What I need to do is on the first...

Hey guys, I have a datafile being sent to me about once a week with various names in 5 different work sheets (4 sheets are individual categories and the last is all the data, which are people's names, on the one sheet)...(btw, not my choice....). Now what I need to do is have excel look at...

Anyone know of a good excel addin to do boxplots (also known as Box & Wisker plot), stem and leaf plots, dot plots? I've searched this forum and google and haven't found anything. I'd prefer freeware but I'll buy if I have to. Thanks again

that sounds like it would work! I'll try it asap. Thanks again.

I don't quite understand what you are suggesting. Could you explain it a little more? I'll try to look everything up in my books in the mean time. Thanks again

I have some data that is grouped in two columns, one is "Score Value" and the other is "Frequency" (or the number with that score). Since there are 1000 total scores, is there a way to data statistical analysis (like mean, mode median, etc) on this data without expanding the data to 1000...

In design mode, pull up the "Page footer" so that it's touching the text in the Detail. The width of the detail space defines the line spacing.

Thank you both for responding. I'll look into both.

I have an Access Database setup that sorts archery scores. I want to export a query to a specific sheet in an Excel file that is setup for playoff bracketing which has formulas that automatically advances the winner of a match to the next round. Now my question is, am I looking at this...

Thanks shades! Just what I was looking for!

Well, I found a major design flaw in my excel workbook. I made all my references relative when I need them to be absolute (ooops.....:o ). Instead of clicking on every cell and changing it, is there a way to change all the references on a sheet to absolute at once (i.e. change =A1 to =$A$1)...

so basically just set the criteria of the query to the value of the combo box? can this be done with an unbound field instead? Would that have to be in the body or the header or does that not matter? and then make an event to requery.... EDIT: That worked perfectly! Thank you so much! I...

That kinda works. I was hoping for something like I search for target #11 (i got the search function working) and the four archers on target 11 pop up and no others. The main reason I want to do this is because the database will be shared and I don't want both computers accessing all the...

First, I apologize if this has been answered before. I've tried searching for it and came up empty. Is there any way to bring up more than one record in a "Columnar" Form? i'm using this database for an archery tournament and what I need is to enter the target number into a search function...

found the problem.....put the wrong field name in....thanks anyways guys

anyone have any ideas? or even a better code for this purpose? please?