RE: Setting up query with multiple data

This data looks nothing like what you started with when you were searching
for "C04" in the string.

What are you trying to do with this data?

"Nick" wrote:

> I have made correction and am still unable to get it to work. I have
> included a sample of the file. 9182037644478802031452 is the actual serch
> item. There are 5 entries.
> query does not work for me. Thanks for your time
> label_id date
> time
> 03041560000413075333 12/20/2004 01:06:42
> 9182037644478802031452 12/20/2004 01:06:42
> 9182037644478802031117 12/20/2004 01:06:56
> 03041560000028421006 12/20/2004 01:06:56
> 9101932495864311932318 12/20/2004 01:07:27
> 9182037644478802031452 12/20/2004 01:07:27
> 9182037644478802031315 12/20/2004 01:07:40
> 420802039101010742567000288901 12/20/2004 01:07:40
> 02946198744085608593 12/20/2004 01:08:29
> 9182037644478802031520 12/20/2004 01:08:29
> 9182037644478802031452 12/20/2004 01:08:45
> 03040370000165834327 12/20/2004 01:08:45
> 9182037644478802031513 12/20/2004 01:08:58
> 9102001206742060225991 12/20/2004 01:08:58
> 9182037644478802031452 12/20/2004 01:09:11
> 420802039102026535096024627362 12/20/2004 01:09:11
> 9102001680594000116481 12/20/2004 01:10:15
> 9182037644478802031452 12/20/2004 01:10:15
>
>
>
>
> "KARL DEWEY" wrote:
>
> > You have a typo. Below corrects the typo.
> >
> > WHERE ((([ALID0001].[LABEL_ID]) Like "*" & [Enter date]& "*" and
> > (ALID0001.LABEL_ID) LIKE "*"& [Enter your search items] & "*"));
> >
> > "Nick" wrote:
> >
> > > I used your example as a guide line, the query askes for the "enter your
> > > search items", Enter date, and then it asks for ALID0001. LABLE_ID.
> > > Please review my query and tell me where I made my error.
> > > Thanks,
> > > SELECT ALID0001.date, [Enter your search items] AS [search items],
> > > Right([label_id],Len([Label_id])-53) AS Items
> > > FROM ALID0001
> > > WHERE ((([ALID0001].[LABEL_ID]) Like "*" & [Enter date]& "*" and
> > > (ALID0001.LABLE_ID) LIKE "*"& [Enter your search items] & "*"));
> > >
> > > "KARL DEWEY" wrote:
> > >
> > > > 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

  • RE: Setting up query with multiple data
    ... I have made correction and am still unable to get it to work. ... 9182037644478802031452 is the actual serch ... query does not work for me. ... Below corrects the typo. ...
    (microsoft.public.access.queries)
  • Re: [OT] Office 2008 for Mac on Amazon...
    ... Michelle Steiner wrote: ... > Yes, I got wrong the person who posted the correction, but Michelle ... > claiming I posted incomprehensible gibberish was a bit over-the-top. ... To those of us who did not recognize it as a typo, ...
    (comp.sys.mac.system)
  • Re: Update field with contents of another field
    ... but everything I find points to typo errors. ... I've looked very closely at the query and find none. ... What is causing that prompt? ... but I get a message saying Syntax error, ...
    (microsoft.public.access.queries)
  • Re: Select Query on a subform within a form
    ... I got the ctrl+G codes to all work now, but when i made the other correction, ... Right-click the edge of the subform control, ... Allen Browne - Microsoft MVP. ... The subform name is statement query ...
    (microsoft.public.access.queries)
  • Re: r-Squared Question
    ... >> applies ONLY to simple regression. ... Never said THAT was a typo. ... The "careless" was referring to ... Your correction of your own post was this: ...
    (sci.stat.math)