Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Delete info in rows 1 and 2 but not 3 and 4

    What would be a fast way to delete all the information under "customers" and "contains" but keep all the "location" spots. I did a append query based on criteria to move the information to the "no...
  2. Replies
    8
    Views
    539

    Thanks Paul-that's what I did. Now I will have a...

    Thanks Paul-that's what I did. Now I will have a master table of locations also. Thanks again
  3. Replies
    8
    Views
    539

    The warehouse locations are A1-01 to A1-55 up to...

    The warehouse locations are A1-01 to A1-55 up to A8-01 to A8-55; then "B" shelf starts and so on taking you up to Z1-01 to Z8-55. Every warehouse location spot is designed to hold a box. As boxes get...
  4. Replies
    8
    Views
    539

    No the "location is not the primary key....

    No the "location is not the primary key. Category,Contents, Location, and Storage date. I'm looking for any locations that might have got deleted in a append and delete query. There are over 14000...
  5. Replies
    8
    Views
    539

    Finding missing numbers

    I'm working in Access 2007. I'm trying to find missing locations. If the location number goes from A1-01 to A1-04 I would like the report/query to give me A1-02 and A1-03
  6. Replies
    1
    Views
    331

    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.
  7. Replies
    5
    Views
    1,372

    Thanks Zeddy, I do have excel 2007

    Thanks Zeddy, I do have excel 2007
  8. Replies
    5
    Views
    1,372

    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...
  9. Replies
    7
    Views
    1,656

    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...
  10. Replies
    2
    Views
    322

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

    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...
  12. 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...
  13. Replies
    3
    Views
    775

    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...
  14. Replies
    3
    Views
    1,277

    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...
  15. Replies
    3
    Views
    1,277

    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...
  16. Replies
    1
    Views
    2,504

    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?
  17. Replies
    3
    Views
    1,254

    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?
  18. Replies
    3
    Views
    1,254

    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...
  19. Replies
    1
    Views
    744

    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...
  20. Thread: Date format

    by buckshot
    Replies
    3
    Views
    807

    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...
  21. 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...
  22. Replies
    5
    Views
    4,668

    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...
  23. Replies
    5
    Views
    4,668

    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?
  24. Replies
    7
    Views
    13,546

    RetiredGeek thank you sooooo much--your the best

    RetiredGeek thank you sooooo much--your the best
  25. Replies
    7
    Views
    13,546

    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...
Results 1 to 25 of 191
Page 1 of 8 1 2 3 4