Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: angels2
  • Order by date
  1. angels2

    FTP access

    I need to add the following to my Pix 506 device any hep would be appreciated. 171.135.1.149 / 171.133.65.80 / ftpst.anywhere.com 170.1.2.25 170.1.2.7 Passive Mode Login Port 20021 Data Port Range 20000 – 22400 (set as ‘outbound only’) 128 bit SSL encryption
  2. angels2

    query help

    Neither one of thos expressions work
  3. angels2

    query help

    I have part numbers 12345-m 12345-h all in one column I want to build an expression to pick only the parts wit ht -h and not the -m what do i need to add to the query to only pull the -h parts
  4. angels2

    Access query help

    Part# QTY Future Current 168DWR 6 5/27/2006 5/27/2006 168DWR 6 5/27/2006 5/27/2006 168DWR 6 5/27/2006 5/29/2006 168DWR 6 5/27/2006 5/29/2006 168DWR 6 5/21/2006 5/22/2006 168DWR 6...
  5. angels2

    can send mail internally will not go out over the inrternet

    I can send mail internally from my domino server but it will not go out over the internet to outside address I can access the internet fronm the pc and have my gateway configured but cannot get message to go out
  6. angels2

    Scheduling an IPL on i5

    How far apart should I set the power off and power on if I want it to power right back on?
  7. angels2

    Scheduling an IPL on i5

    I would like to schedule an IPL for Sunday Morinings on my i5 I use the Go Power but need help from there to create the schedule I would like it to do an IPL at 3am Sun morning Thanks for help
  8. angels2

    Query for no data in cell

    I have a query with 4 fields 3 of the 4 fileds always contain data. 1 field contains some data not always. I want to run a query from this query to give me all 4 fields but in the 1 field that does not always contain data I want just the blank one to run in my query>
  9. angels2

    Adding days to date

    I do not know if this can be done I am pulling my information from an as400 db2 into a table then running a query and want to ad 1 day to a date field which is no problem except for Friday I need to add 3 to bypass Sat and Sun and move Friday's date to Monday is this possible?
  10. angels2

    query help

    Thank you worked just like I wanted
  11. angels2

    query help

    I am running a query containing several dates in one field I put the date criteria in the query and receive the answer for that date. I would like to create a date input option in the query instead of editing. I want to run the query and hve a popup box to type in date then run the query for a...
  12. angels2

    Brother Printer pages printing with gray background

    I have a Brother printer I have changed the drum and toner but the pages are still coming out with a grayish black background anyone have any suggestions
  13. angels2

    Error writing to LPT1

    I have a Hp designjet 430 an when I try to print I get the following error Error writing to LPT1 test page device not connected retry or cancel the job. I have a deskjet 610 and it is printing fine with usb connection. I have checked to make sure the ports are enabled in bios and device manager...
  14. angels2

    Access Query Help

    Thanks again
  15. angels2

    Access Query Help

    That worked perfect I got the user what he wanted I have another question which may not be able to do but is there a way to group each part by month and the the total for month I would like to get the same results but on a monthly bases. I am trying to get sales results for last 3 years month...
  16. angels2

    Access Query Help

    I got it thank you very much
  17. angels2

    Access Query Help

    Thanks for the reply I am very new to Access can you better explain where I need to put the formula's
  18. angels2

    Access Query Help

    I should have left out the date but I want the other columns to come out like this with the part number only once and amounts totaled for each part number DIPART DIDESC DHTOTI 48605-02010-H LOWER ARM 7526.68 53211-04903-H SUPPORT 132,270 53301-AA040-H HOOD...
  19. angels2

    Access Query Help

    What have I asked that is wrong I do not understand the last post
  20. angels2

    Access Query Help

    DHIDAT DIPART DIDESC DHTOTI 10/12/2004 48605-02010-H LOWER ARM 1813.66 10/12/2004 48605-02010-H LOWER ARM 2176.38 10/13/2004 48605-02010-H LOWER ARM 1692.75 10/13/2004 48605-02010-H LOWER ARM 1843.89 5/5/2004 53211-04903-H SUPPORT 23003.88 12/3/2004 53211-04903-H SUPPORT...

Part and Inventory Search

Back
Top