Recent content by jannecum

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.