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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. jannecum

    Remove Hard returns in Excel

    Thanks John, That is very helpful.
  2. jannecum

    Remove Hard returns in Excel

    Thank you Glenn - that seems to work pretty good. Where can I locate a list of code number combinations for this type of task? Julie C
  3. jannecum

    Remove Hard returns in Excel

    Using Excel '97 and I have Hard returns ([Alt] + {Enter]) and they show up as small squares in excel cells. I would like to search & replace them with "; " but I am not having any luck. I have tried to copy the little square and paste it into the search field but it will not copy... Any...
  4. jannecum

    Access 97 Query returning incorrect Data

    Yes adding the following parameter at the beginning of Query also works. Thanks a million! Julie C PARAMETERS [ENTER A LOCATION] IEEEDouble; SELECT DEPT1F.DEPARTMENT, DEPT1F.DeptNo, DEPT1F.HEAD, DEPT1F.LIAISON, DEPT1F.PHONE, DEPT1F.EXT, DEPT1F.NOTE, DEPT1F.LastUpdate, DEPT1F.UserName...
  5. jannecum

    Access 97 Query returning incorrect Data

    Thank you for all the help to figur this out. Lameid - even thoough I did get the guery to work with the -0's, I will also try working with the parameters. I also do not usually mess with these. Thanks Janne
  6. jannecum

    Access 97 Query returning incorrect Data

    Bill, Thanks for all your help..... This was a real stinker for me and I do queries all the time. For some unknown reason ##$@(*&^ I had to add -0 to the [ENTER A LOCATION] like this: WHERE (((RCMGT.LOC1)<=[ENTER A LOCATION-0) AND (([LOC1]+[RECV]+[FILMIN]-[DISPOSE]-[RETURN]-1)>=[ENTER A...
  7. jannecum

    Access 97 Query returning incorrect Data

    The fields sort like number fields should so I do not understand why they are having a problem with the number of digits in the criteria section of the query.
  8. jannecum

    Access 97 Query returning incorrect Data

    It is a general number field (Double) I have changed the number format with leading zeros so all numbers were the same length but still no change in the records returned....
  9. jannecum

    Access 97 Query returning incorrect Data

    I just realized the problem is with the number of digits in the locations. If I am looking for a 4 digit location it finds the correct location but also all 3 digit locations. If I look for a 2 digit location it returns the correct location plus 1 digit locations. If I look for a 1 digit...
  10. jannecum

    Access 97 Query returning incorrect Data

    The records that are returned that are incorrect are all 2-3 digit numbers compared to a four digit number I am looking for???? Is my formating a problem here?
  11. jannecum

    Access 97 Query returning incorrect Data

    [ENTER A LOCATION] is greater than [LOC1] AND Less than ([LOC1]+[RECV]+[FILMIN]-[DISPOSE]-[RETURN]-1) so have entered your one criteria: WHERE (((RCMGT.LOC1)<=[ENTER A LOCATION]) AND (([LOC1]+[RECV]+[FILMIN]-[DISPOSE]-[RETURN]-1)>=[ENTER A LOCATION])); & it still results in locations being...
  12. jannecum

    Access 97 Query returning incorrect Data

    this is what I have for my third set of criteria but it still brings back too many records. NOTE: I have changed [enter loc no] to [ENTER A LOCATION] WHERE ((RCMGT.LOC1)>=[ENTER A LOCATION]) AND (([LOC1]+[RECV]+[FILMIN]-[DISPOSE]-[RETURN]-1)<=[ENTER A LOCATION]));
  13. jannecum

    Access 97 Query returning incorrect Data

    Thanks for the reply. No matter how I put this in it still returns the correct record plus all records where [LOC1] is < [enter Loc no] even though I have the criteria listed that (RCMGT.LOC1)>[enter Loc no]). It is like it is ignoring this piece of criteria ????? I have worked on this for...
  14. jannecum

    Access 97 Query returning incorrect Data

    Need help with following Query where User enters a Location Number and Records for that location are returned. Line 1 & line 2 criteria work if the location requested matches the beginning Location or ending location but I can not get line 3 criteria to return records where the requested...
  15. jannecum

    Filter expressions

    Lameid, Thank you for sharing that method. I was able figure the proper criteria after looking at a query in SQL view. I will remember this for future use also - thank you.
  16. jannecum

    Filter expressions

    Where can I find examples of expressions to use in the "filter for" operation in a form view or datasheet view in MS Access? specifically I want to filter for all "TF" and all "BR" in a field called type.
  17. jannecum

    Trouble Sorting multiple columns in datasheet view

    TheAceMan1, I finally got it. a simple thing - My error was: If you have any of the fields tab properties set to no tab it does not allow the column to be sorted in the datasheet view. So if sorting is required the way I do it all tabs should be "yes". Thanks again.
  18. jannecum

    Trouble Sorting multiple columns in datasheet view

    For the application I use, pre-determining any sort criteria in the datasheet view of the form will not assist me in the variety of sort orders I need to do. I do use preset sorts in my reports and in other forms where I do use the setting for continous forms, but I do want the option of...
  19. jannecum

    Trouble Sorting multiple columns in datasheet view

    These are the Help instructions for what I am trying to do: It says you can sort adjacent columns but my asending/decending controls become inoperable when I select adjacent columns Sort records in Form or Datasheet view For a list of issues to consider when sorting records, click . 1 In...
  20. jannecum

    Trouble Sorting multiple columns in datasheet view

    I really do not want a predesigned sort - I can do them. I want to highlight datasheet columns that are next to each other and sort all three ascending or decending, but when I try to do this me ascending and decending controls on the menu bar become dim and are not functioning.

Part and Inventory Search

Back
Top