I'm using a two column list of words, and I need the first column of words to be exactly 8 letters or less. How can I limit the length of the words in this column to 8 letters?
Thanks
Type: Posts; User: papabill
I'm using a two column list of words, and I need the first column of words to be exactly 8 letters or less. How can I limit the length of the words in this column to 8 letters?
Thanks
If I knew what you needed to know, I'd comply.
I have ONE table with all the information I need for our members. Name, address, birthdate, anniversary date, names & info of kids, pictures, etc.
...
I'm still working on our church directory, and I need to know (using Access 2007) if there is a way to use the results of two queries in one report?
Otherwise I'll have a LOT of wasted space. The...
I have a simple database with a membership list that has birth dates and anniversary dates entered as MM/DD/YYYY, but in the report I want them to display as MM/DD. (Some of our members don't want...
Sure, why not
"If you look at the Access templates you'll find one for contact management that includes the ability to add a picture.
As for First Name/Last Name you can concatenate them in a...
I am trying to build a very simple database for our church members so I can eventually publish a member directory (with pictures). The FIRST problem I'm having right now is trying to take two fields...
Yep, just did, thanks
I'm using Excel 2007
I'm sorry, but that makes no sense at all to me. Here is what I am seeing:
aa1 0.679587508 #NAME?
aa2 0.609065555 #NAME?
Am I supposed to put this in a...
Outstanding, thanks, but I see that there are several duplications. Any way to stop that?
I am trying to complete a meal plan that uses 31 different entrees. I have column A numbered from 1 to 31. Column B has the name of the entrée.
I want to use an "=randbetween(1,31)" to pick out an...
The only thing that came through was a page (SHEET 2) of numbers, with "=RAND()" as the ONLY formula in each cell. Sorry, but nothing about it makes sense.
Sorry, Originally the Veg1 and Veg2 columns were identical (until my brain figured out more vegetables) and I didn't want the same veg twice
1635
How do I post a sample spreadsheet?
Thanks
I appreciate all the help I have gotten in the past, and I realize that I ask some of the dumbest questions, but I need help again.
I have need of a formula using the random feature.
I have...
I'm sorry, I'm not a programmer, so this is totally unknown to me. I'm gonna need some actions to take in the spreadsheet itself.
Thanks
Well, I'm at it again, trying to get this spreadsheet to do what I need it to do. So far, so good, thanks to all the help from everyone here.
Now, I need to protect ONLY certain parts of the...
I understand now, thanks.
Can you explain something for me? I understand MOST of the formula, but not all. =TIME(6,RANDBETWEEN(0,180),0)
I understand the 6 (6 oclock) and the 180 (180 minutes-three hours past 6 = 9), but...
Thanks to all you for the help. Now I can create a good schedule.
That seems to work well, but the products are very random. I still need to control them.
How do I put it so it will give me times between 6 - 9am, 11am - 2pm, 6pm - 8pm, and 11pm - 12:30am
...
I've been able to create random numbers, but I cannot create random times. For example, I want to create a schedule of training and use random times to call the group together (between 6:30 and 9:00,...
Thanks so much.
I'm sorry to keep asking such seemingly simple questions, but this one has caused me several days of hunting without finding an answer.
How do I set the spreadsheet to go to the cell on the right...