Re: Can I create a date field in a make table query?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"my current method" is my going into Table Design and MANUALLY changing the field type from Text to
Date, after I build the table. Like I said. There *IS* no code to *change* it, just *build* it:

Serv Start: IIf([UTSSYY]>50,[UTSSMM] & "/" & [UTSSDD] & "/" & (1900+([UTSSYY])),[UTSSMM] & "/" &
[UTSSDD] & "/" & (2000+([UTSSYY])))

So the question is, can I specify that this field be of type "Date" in my query, and if so, how?

On Tue, 18 Jul 2006 15:51:32 -0500, "Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote:

What is "my current method"? We haven't seen any code, query, sql, sample
data, values,...
.

Relevant Pages

  • Re: Problems with Date conversion from text format into date/time...
    ... >> do a make table query, then go in to design view to change the field type ... >> from text to date/time, ... Prev by Date: ...
    (comp.databases.ms-access)
  • Table documentation
    ... I am using MSAccess 2000. ... When I see a table in design view I see the Field Name, Field Type, and ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Where to find the Data Type to change a field to text
    ... You would open the table in design view and change the field type, ... your forms, queries, and reports. ... Rick B ...
    (microsoft.public.access.forms)
  • Re: Date Format - Credit Card Expiry
    ... >> I have done a bit of testing I think using the date field type is not ... >> Alex White MCDBA MCSE ... >>> this in the table design or is this effected in the form? ...
    (microsoft.public.access.tablesdbdesign)
  • RE: decimal not showing correctly in append query
    ... The field type Long Integer means there are no decimal places even if you ... specify some. ... "naiveprogrammer" wrote: ... > I have an append query that is not showing the cents in a number field. ...
    (microsoft.public.access.queries)