Search:

Type: Posts; User: papabill

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. How To Limit The Word Length Or Number Of Characters In A Cell

    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
  2. Replies
    3
    Views
    3,321

    If I knew what you needed to know, I'd comply. ...

    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.
    ...
  3. Replies
    3
    Views
    3,321

    Building reports

    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...
  4. Replies
    1
    Views
    2,461

    Displaying dates in reports as MM/DD

    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...
  5. Replies
    2
    Views
    3,140

    Sure, why not "If you look at the Access...

    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...
  6. Replies
    2
    Views
    3,140

    Concatenate Two Fields In MS-Access

    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...
  7. Replies
    8
    Views
    1,814

    Yep, just did, thanks

    Yep, just did, thanks
  8. Replies
    8
    Views
    1,814

    I'm using Excel 2007

    I'm using Excel 2007
  9. Replies
    8
    Views
    1,814

    I'm sorry, but that makes no sense at all to me....

    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...
  10. Replies
    8
    Views
    1,814

    Outstanding, thanks, but I see that there are...

    Outstanding, thanks, but I see that there are several duplications. Any way to stop that?
  11. Replies
    8
    Views
    1,814

    Unique Random Numbers Using Formula

    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...
  12. The only thing that came through was a page...

    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.
  13. Sorry, Originally the Veg1 and Veg2 columns were...

    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
  14. 1635

    1635
  15. How do I post a sample spreadsheet? Thanks

    How do I post a sample spreadsheet?

    Thanks
  16. Get Combination Of Unique Values From N Columns Using Rand Or RandBetween Function

    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...
  17. Replies
    17
    Views
    3,753

    I'm sorry, I'm not a programmer, so this is...

    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
  18. Replies
    17
    Views
    3,753

    Well, I'm at it again, trying to get this...

    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...
  19. I understand now, thanks.

    I understand now, thanks.
  20. Can you explain something for me? I understand...

    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...
  21. Thanks to all you for the help. Now I can create...

    Thanks to all you for the help. Now I can create a good schedule.
  22. That seems to work well, but the products are...

    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


    ...
  23. Random Time Between Fixed Lower And Upper Limits

    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,...
  24. Thanks so much.

    Thanks so much.
  25. How To Make The Enter Key Make Cell Selection Move To Right In Excel

    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...
Results 1 to 25 of 33
Page 1 of 2 1 2