Search:

Type: Posts; User: buckshot; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    242

    Change Year format on imported database

    I have Access 2007 that I suck in a report that has the date 07/08/15, how can you change that to 07/08/1915. I need that 4 digit year format.
  2. Replies
    5
    Views
    748

    Thanks Zeddy, I do have excel 2007

    Thanks Zeddy, I do have excel 2007
  3. Replies
    5
    Views
    748

    Cover Sheet results

    I have a cover sheet (listing the Months from which I get results like name, apartment number, payments)
    Months
    A2 Jan-April 2015 typed in
    A3 May-Aug 2015 typed in
    A4 Sept-Dec 2015 typed in

    My...
  4. Replies
    7
    Views
    1,229

    Joining two unrelated tables

    I have 2 tables one is a active and one is a inactive. The information is moved from the active table to the inactive table once the patient becomes inactive. If I'm searching for John Johnson I have...
  5. Replies
    2
    Views
    272

    Date search problem

    I had excel 2003 and now have 2010, when I search for a date 04/05/1982 excel 2010 will not find it that way. Now I have to type 4/5/1982-I have changed the date to custom mm/dd/yyyy and that does...
  6. Replies
    7
    Views
    2,653

    Playing two videos at the same time

    Iím trying to play two videos at the same time on the same slide in powerpoint 2007. It plays one video then it plays the 2nd on after the first one is done. This is ok but I would like the videos to...
  7. VLookup over multiple worksheets Excel 2003

    My coversheet is set up to look at 2 different worksheets--Excel 2003 not 2007 or 2010
    I'm using this formula =VLOOKUP($B$4,'Warehouse 1 to 199999'!$A$2:$G$54224,2,FALSE)
    It works great but it will...
  8. Replies
    3
    Views
    658

    Converting DOB

    I have a date of birth that came in to my Access 2003 like this
    19680622
    So I used this formula to convert it to 06/22/1969
    Mid([DOB],5,2) & "/" & Right([DOB],2) & "/" & Left([DOB],4)

    which is...
  9. Replies
    3
    Views
    1,195

    The table structure is the contents in box and...

    The table structure is the contents in box and the locations of the box is all in one table. The table fields are- Date sent to warehouse, Contents of what is in your box, Location of the shelf the...
  10. Replies
    3
    Views
    1,195

    Find a number between two numbers

    Hi all
    I have a warehouse access Database it has the Contents in this box and the locations of the box. My Contents will contain charts between 500-88400 this box will be located on B3-28A, my next...
  11. Replies
    1
    Views
    2,291

    Change date format Access 2003

    I have a date of 08/12/11. I would like it to have 08/12/2011-how can this be done in Access 2003?
  12. Replies
    3
    Views
    1,166

    I would like it to run a report on it's own. I'm...

    I would like it to run a report on it's own. I'm using access 2003. How can this be done?
  13. Replies
    3
    Views
    1,166

    automatically send a email

    Can you automatically send a email from microsoft access to outlook on the 1st of every month? We keep our birthday list in access and would like the list of everyone having a birthday that month to...
  14. Replies
    1
    Views
    692

    Trouble getting rid of text

    I imported a access file -the word NO is listed under Exp if the person did not die. I can not get rid of the word NO. There is no default value listed. I get a popup saying "You can't replace the...
  15. Thread: Date format

    by buckshot
    Replies
    3
    Views
    756

    Date format

    A database was sent to me with the dates 01/02/48 -with two spaces before the 01 for some reason.
    I would like it to be 01/02/1948. Right click format does not work. Here is a copy of the database...
  16. How do you trim the last letter in access 2003?

    If more then 1 letter is at the end of a persons name after the last space do nothing but if only 1 letter is after the name then take that letter off in access 2003?
    Smith,John A--I would want to...
  17. Replies
    5
    Views
    4,294

    I'm not sure how to write that Result =...

    I'm not sure how to write that
    Result = DateOfDeath - DOB
    would it be in the query or on the form that I'm using?
    How do you even write that? Result:([DateOfDeath-[DOB]) this did not work for me I...
  18. Replies
    5
    Views
    4,294

    Subtract 2 dates in access 2003

    Hi I have a form that I'm working in--how does access subtract the DOB from the date of death? would it have to be in the query or in the form?
  19. Replies
    7
    Views
    11,119

    RetiredGeek thank you sooooo much--your the best

    RetiredGeek thank you sooooo much--your the best
  20. Replies
    7
    Views
    11,119

    Update records from excel into access

    I would like to update records to the deceased section in access from a excel spreadsheet.
    I have a access dbase with patient #, name, and a deceased date. The Excel spreadsheet is setup the same...
  21. Replies
    2
    Views
    1,332

    Keep the starting 0's

    Hi I have a database A1=00 A2=66 A3=08-- what I need it to look like is 00-66-08 or 006608 with the 0 before the 0 in A1 and the 0 before the 8 in A3. How, How, How can this be done????
  22. Replies
    2
    Views
    1,102

    Cut the last character after a space

    I need to get rid of the middle initial if they have one. It's always at the end after a space. example John Smith A.
    in Excel 2000
    Thanks so much
  23. Replies
    1
    Views
    813

    Get rid of space after a comma

    I need to get rid of space after a comma. Example John, Smith K. I need it to look like John,Smith K
    I have Excel 2000
  24. Thread: Missing data

    by buckshot
    Replies
    3
    Views
    815

    Column A contains Names--B contains addresses...

    Column A contains Names--B contains addresses --and C contains Zip
  25. Thread: Missing data

    by buckshot
    Replies
    3
    Views
    815

    Missing data

    I would like to get the Zip Codes into database 1 from database 2. Database 1 has names, addresses, but No Zip Codes and contains only 2000 people. Database 2 has Names, Addresses, and Zip codes. It...
Results 1 to 25 of 186
Page 1 of 8 1 2 3 4