Re: Creating empty date field with make-table query
From: Nikos Yannacopoulos (nyannacoREMOVETHISBIT_at_in.gr)
Date: 05/24/04
- Next message: Hamoud: "Query question"
- Previous message: Shane: "Urgently need help with a database file!!!!!!"
- In reply to: Gary Walter: "Re: Creating empty date field with make-table query"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 May 2004 11:03:51 +0300
Brilliant!
"Gary Walter" <garylwpleasenospam@wamego.net> wrote in message
news:eEaML3MQEHA.2468@tk2msftngp13.phx.gbl...
> Hi TT,
>
> just in case "TT" <> 'tt' (other post)
>
> Another clever method Michel once demonstrated:
>
> NewField: IIf(True,Null,#1/1/1900#)
>
> -- you end up with date/time field, all nulls
>
> -- works for text and number also
> NewField: IIf(True,Null," ") <--get type text(255), all null
> NewField: IIf(True,Null,0) <--get type Long, all null
>
> -- or use Cxxx functions
> NewField: IIf(True,Null,CCur(0)) <--get type Currency, all
null
> NewField: IIf(True,Null,CDbl(0)) <--get type Double, all
null
>
> So clever...and eliminate "binary type" bugaboo
> when you use
>
> NewField: Null
>
> Please respond back if I have misunderstood.
>
> Good luck,
>
> Gary Walter
>
>
> "TT" <anonymous@discussions.microsoft.com> wrote in message
> news:fc1301c43e7b$403aee80$a401280a@phx.gbl...
> > I am trying to create a new table using a make-table query
> > where one of the fields is formatted as a date but has no
> > data in it initially.
>
>
- Next message: Hamoud: "Query question"
- Previous message: Shane: "Urgently need help with a database file!!!!!!"
- In reply to: Gary Walter: "Re: Creating empty date field with make-table query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
