Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Access 07 Query
From:	Harry Lichtbach <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Sat, 27 Oct 2001 21:10:09 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (30 lines)

George, write you query selection field as "*Apr 97*", or any other month and
year combination.  (Those are asterisk on both sides of your month/year
combination.)  This is probably not the best data base design for what you are
doing, but if its expedited ...

On Sat, 27 Oct 2001 16:55:06 -0400, George Helm <[log in to unmask]> wrote:

>I am using MS Access 97.
>
>Each Name will have multiple entries in the "Dates of Use" field.  The
>field format is "Apr 97, Aug 98, Aug 99, Jan 00"...
>
>I would like to build a Query that will search only "Dates of Use"
>field
>for Aug 99 or any month year combination I choose from the multilpe
>entries in this field.
>
>Your help is appreciated in setting the criteria.
>
>George G. Helm

*-*-*-*-*-*-*
Harry Lichtbach
Evergreen Valley College
San Jose, CA, USA

      "Hold No Punches.." Rode brings you great shareware/freeware
        programs with his honest opinions in this weekly column.
                       http://freepctech.com/rode

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG