Johnny C wrote:
I have the following tables:
TABLE A
month | year | item | num
1 2005 myitem 003
TABLE B
num| date | descr
003 02-01-2005 blahblah
003 01-01-2005 toratora
I am trying to come up with
On Thu, Feb 10, 2005 at 17:45:11 -0500,
Johnny C <[EMAIL PROTECTED]> wrote:
>
> How can you make month (append) - 01 - (append) year? and
> pass that as a condition to the field date? Is this possible?
You can EXTRACT the day of the month from the date. If you need this
to use an index, you can
I have the following tables:
TABLE A
month | year | item | num
1 2005 myitem 003
TABLE B
num| date | descr
003 02-01-2005 blahblah
003 01-01-2005 toratora
I am trying to come up with something li
