When I put in 1,2,3,4, or 5 all items beginning with that number o

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Access 2003 query I have a parameter aking the user to put in the
number of the item they are changing. The number go from 1 -1800 and then
begin again at 5001. When a number from 1 - 5 is put in, i.e. they are
looking for item no. 1, 2, 3, 4, or 5 all items beginning with those numbers
open. The requests are run off a paramter query. But if I put in for
example 23, only 23 opens. I have never had this happen and am not sure
where to begin looking to solve this issue.
 
Here it is:

SELECT TBL_ECR.*, TBL_ECR.Priority, TBL_ECR.Status, TBL_ECR.Coordinator
FROM TBL_ECR
WHERE (((TBL_ECR.Priority)="A" Or (TBL_ECR.Priority)="B" Or
(TBL_ECR.Priority)="C" Or (TBL_ECR.Priority)="TBA" Or (TBL_ECR.Priority) Is
Null Or (TBL_ECR.Priority)="D" Or (TBL_ECR.Priority)="E" Or
(TBL_ECR.Priority)="Z") AND ((TBL_ECR.Status)<>"Complete" And
(TBL_ECR.Status)<>"Rejected" And (TBL_ECR.Status)<>"ECR-Complete") AND
((TBL_ECR.Coordinator) Like [What is the Coordinator's Name] & "*"))
ORDER BY TBL_ECR.Priority, TBL_ECR.Status;
 
The SQL you posted does not prompt for item number. I will prompt for "What
is the Coordinator's Name."



Leslie said:
Here it is:

SELECT TBL_ECR.*, TBL_ECR.Priority, TBL_ECR.Status, TBL_ECR.Coordinator
FROM TBL_ECR
WHERE (((TBL_ECR.Priority)="A" Or (TBL_ECR.Priority)="B" Or
(TBL_ECR.Priority)="C" Or (TBL_ECR.Priority)="TBA" Or (TBL_ECR.Priority) Is
Null Or (TBL_ECR.Priority)="D" Or (TBL_ECR.Priority)="E" Or
(TBL_ECR.Priority)="Z") AND ((TBL_ECR.Status)<>"Complete" And
(TBL_ECR.Status)<>"Rejected" And (TBL_ECR.Status)<>"ECR-Complete") AND
((TBL_ECR.Coordinator) Like [What is the Coordinator's Name] & "*"))
ORDER BY TBL_ECR.Priority, TBL_ECR.Status;

Jerry Whittle said:
Please post the SQL for the query.
Click to expand...
Click to expand...
 
I'm terribly sorry, here is the correct SQL:

SELECT [TBL_File-Move-Form].ECR_PC_No,
[TBL_File-Move-Form].[ECR-PCNo-PreviousSystem],
[TBL_File-Move-Form].[Engineering Personnel], [TBL_File-Move-Form].Date,
[TBL_File-Move-Form].[File Name-BOM-or-WI], [TBL_File-Move-Form].[Original
Revision], [TBL_File-Move-Form].[New Revision], [TBL_File-Move-Form].[Product
Drive-Master], [TBL_File-Move-Form].[Product Drive-Master Date],
[TBL_File-Move-Form].[BOM Change Initials], [TBL_File-Move-Form].[BOM Change
Date], [TBL_File-Move-Form].[Fabricated at PDQ],
[TBL_File-Move-Form].DWGtoFloor, [TBL_File-Move-Form].ProductLine
FROM [TBL_File-Move-Form]
WHERE ((([TBL_File-Move-Form].ECR_PC_No) Like [What is the ECR or PC
Number?] & "*"))
ORDER BY [TBL_File-Move-Form].ECR_PC_No;


KARL DEWEY said:
The SQL you posted does not prompt for item number. I will prompt for "What
is the Coordinator's Name."



Leslie said:
Here it is:

SELECT TBL_ECR.*, TBL_ECR.Priority, TBL_ECR.Status, TBL_ECR.Coordinator
FROM TBL_ECR
WHERE (((TBL_ECR.Priority)="A" Or (TBL_ECR.Priority)="B" Or
(TBL_ECR.Priority)="C" Or (TBL_ECR.Priority)="TBA" Or (TBL_ECR.Priority) Is
Null Or (TBL_ECR.Priority)="D" Or (TBL_ECR.Priority)="E" Or
(TBL_ECR.Priority)="Z") AND ((TBL_ECR.Status)<>"Complete" And
(TBL_ECR.Status)<>"Rejected" And (TBL_ECR.Status)<>"ECR-Complete") AND
((TBL_ECR.Coordinator) Like [What is the Coordinator's Name] & "*"))
ORDER BY TBL_ECR.Priority, TBL_ECR.Status;

Jerry Whittle said:
Please post the SQL for the query.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

In an Access 2003 query I have a parameter aking the user to put in the
number of the item they are changing. The number go from 1 -1800 and then
begin again at 5001. When a number from 1 - 5 is put in, i.e. they are
looking for item no. 1, 2, 3, 4, or 5 all items beginning with those numbers
open. The requests are run off a paramter query. But if I put in for
example 23, only 23 opens. I have never had this happen and am not sure
where to begin looking to solve this issue.
Click to expand...
Click to expand...
Click to expand...
 
WHERE ((([TBL_File-Move-Form].ECR_PC_No) Like [What is the ECR or PC
Number?] & "*"))

Change to this --
WHERE ((([TBL_File-Move-Form].ECR_PC_No) = [What is the ECR or PC
Number?] ))

This requires the exact data entry.

Leslie said:
I'm terribly sorry, here is the correct SQL:

SELECT [TBL_File-Move-Form].ECR_PC_No,
[TBL_File-Move-Form].[ECR-PCNo-PreviousSystem],
[TBL_File-Move-Form].[Engineering Personnel], [TBL_File-Move-Form].Date,
[TBL_File-Move-Form].[File Name-BOM-or-WI], [TBL_File-Move-Form].[Original
Revision], [TBL_File-Move-Form].[New Revision], [TBL_File-Move-Form].[Product
Drive-Master], [TBL_File-Move-Form].[Product Drive-Master Date],
[TBL_File-Move-Form].[BOM Change Initials], [TBL_File-Move-Form].[BOM Change
Date], [TBL_File-Move-Form].[Fabricated at PDQ],
[TBL_File-Move-Form].DWGtoFloor, [TBL_File-Move-Form].ProductLine
FROM [TBL_File-Move-Form]
WHERE ((([TBL_File-Move-Form].ECR_PC_No) Like [What is the ECR or PC
Number?] & "*"))
ORDER BY [TBL_File-Move-Form].ECR_PC_No;


KARL DEWEY said:
The SQL you posted does not prompt for item number. I will prompt for "What
is the Coordinator's Name."



Leslie said:
Here it is:

SELECT TBL_ECR.*, TBL_ECR.Priority, TBL_ECR.Status, TBL_ECR.Coordinator
FROM TBL_ECR
WHERE (((TBL_ECR.Priority)="A" Or (TBL_ECR.Priority)="B" Or
(TBL_ECR.Priority)="C" Or (TBL_ECR.Priority)="TBA" Or (TBL_ECR.Priority) Is
Null Or (TBL_ECR.Priority)="D" Or (TBL_ECR.Priority)="E" Or
(TBL_ECR.Priority)="Z") AND ((TBL_ECR.Status)<>"Complete" And
(TBL_ECR.Status)<>"Rejected" And (TBL_ECR.Status)<>"ECR-Complete") AND
((TBL_ECR.Coordinator) Like [What is the Coordinator's Name] & "*"))
ORDER BY TBL_ECR.Priority, TBL_ECR.Status;

:

Please post the SQL for the query.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

In an Access 2003 query I have a parameter aking the user to put in the
number of the item they are changing. The number go from 1 -1800 and then
begin again at 5001. When a number from 1 - 5 is put in, i.e. they are
looking for item no. 1, 2, 3, 4, or 5 all items beginning with those numbers
open. The requests are run off a paramter query. But if I put in for
example 23, only 23 opens. I have never had this happen and am not sure
where to begin looking to solve this issue.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top