Search results for query: *

Thanks John, That is very helpful.

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

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

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

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

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

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.

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

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

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?

[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...

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]));

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

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

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.

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.

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.

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

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

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.