RE: Setting up query with multiple data

This should do it --
SELECT [Enter date - 01/02/04] AS [Date scanned], [Enter your search item -
C04] AS [Search item], Right([YourDataField],Len([YourDataField])-53) AS Items
FROM YourTable
WHERE (((YourTable.YourDataField) Like "*" & [Enter date - 01/02/04] & "*"
And (YourTable.YourDataField) Like "*" & [Enter your search item - C04] &
"*"));


"Nick" wrote:

> I am unable to seperate scanns or the tables. this is an imported file and
> the way you see it is the way it comes in. Somewhere within the scanned
> items will be the C0* record. I am at a loss.
>
> "KARL DEWEY" wrote:
>
> > Your table is wrong. Use a separate entry for each item scaned. Two ways to
> > do it.
> > tblScanItems--
> > Item - text field
> > ScanDate - datetime field
> > Optional
> > ScanTime - datetime field
> > Scanner - text - who done it
> >
> > The other way.
> > tblScan--
> > ScanID - autonumber - Primary Key
> > ScanDate - datetime
> > Scanner - text
> >
> > tblScanItems--
> > ScanID - number - long interger
> > Item - text field
> >
> > Create a one-to many relation tblScan.ScanID to tblScanItems.ScanID
> >
> >
> > "Nick" wrote:
> >
> > > I want to sort by the "C04" part of the records. The data connected to the
> > > Datestamp and DateScanned can be a string of entries or just one, with the
> > > "C*" record in it.
> > > Example
> > > Datestamp 11:00 DateScanned 08/10/05 Items scanned C04, 3333, 222, and 888
> > > Datestamp 12:00 DateScanned 08/10/05 Items scanned C03, 3030, and 202
> > > Datestamp 12:01 DateScanned 08/10/05 Items scanned 1010, and C04
> > > Datestamp 1:00 DateScanned 08/10/05 Items scanned 1111, C04, and 20
> > > Datestamp 1:20 DateScannec 08/10/05 Items scanned C40, 77777, and 15
> > > I am not sure what other information is required to get this to work.
> > > but in this example, the query should show a date of 08/10/05; C04, with the
> > > list of Items scanned; 3333,222,888,1010,1111,20,77777 and 15.
> > >
> > >
> > >
.

Relevant Pages
Loading