RE: Setting up query with multiple data

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
    ... for "C04" in the string. ... > I have made correction and am still unable to get it to work. ... Below corrects the typo. ... >>> Please review my query and tell me where I made my error. ...
    (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)
Loading