G
Guest
I want to sort by the "8027" part of the records. The data connected to the
Datestamp and date can be a string of entries or just one, with the "802*"
record in it.
This is an imported file and the way you see it is the way it comes.
Somewhere within the scanned items will be an 802* record.
Example: table name ALID0001
Datestamp 11:00 date 08/10/05 label_id 8027, 3333, 222, and 888
Datestamp 12:00 date 08/10/05 label_id 8029, 3030, and 202
Datestamp 12:01 date 08/10/05 label_id 1010, and 8027
Datestamp 1:00 date 08/10/05 label_id 1111, 8027, and 20
Datestamp 1:20 date 08/10/05 label_id 8027, 77777, and 15
In this example, the query should show a date of 08/10/05; 8027, with the
list of Items scanned; 3333,222,888,1010,1111,20,77777 and 15
Karl helped with this query but I have been unable to get it to work. When
I insert the “8027†in the query request [Enter your search item –8027] it
returns a blank query
SELECT [Enter date - 01/02/04] AS [DATE], [Enter your search item -8027] AS
label_id, Right([ALID0001].[label_id],Len([ALID0001].[label_id])-53) AS Item
FROM ALID0001
WHERE (((ALID0001.label_id) Like "*" & [Enter date - 01/02/04] & "*" And
(ALID0001.label_id) Like "*" & ([Enter your search item -8027]) & "*"));
Sorry to resubmit question,
Thanks!
Datestamp and date can be a string of entries or just one, with the "802*"
record in it.
This is an imported file and the way you see it is the way it comes.
Somewhere within the scanned items will be an 802* record.
Example: table name ALID0001
Datestamp 11:00 date 08/10/05 label_id 8027, 3333, 222, and 888
Datestamp 12:00 date 08/10/05 label_id 8029, 3030, and 202
Datestamp 12:01 date 08/10/05 label_id 1010, and 8027
Datestamp 1:00 date 08/10/05 label_id 1111, 8027, and 20
Datestamp 1:20 date 08/10/05 label_id 8027, 77777, and 15
In this example, the query should show a date of 08/10/05; 8027, with the
list of Items scanned; 3333,222,888,1010,1111,20,77777 and 15
Karl helped with this query but I have been unable to get it to work. When
I insert the “8027†in the query request [Enter your search item –8027] it
returns a blank query
SELECT [Enter date - 01/02/04] AS [DATE], [Enter your search item -8027] AS
label_id, Right([ALID0001].[label_id],Len([ALID0001].[label_id])-53) AS Item
FROM ALID0001
WHERE (((ALID0001.label_id) Like "*" & [Enter date - 01/02/04] & "*" And
(ALID0001.label_id) Like "*" & ([Enter your search item -8027]) & "*"));
Sorry to resubmit question,
Thanks!