query in access

Results 1 to 2 of 2

Thread: query in access

  1. #1
    Join Date
    Dec 1969

    Default query in access

    I have linked tables from sequel into access. I want to query off of a date/time field in access. When I run the query it prompts the user to enter a date. Although in the sequel server database table I have mm/dd/yyyy hh:mm:ss, in the access table I have format short date or mm/dd/yyyy. I still can not get this to work.<BR>....And (([dbo_TFHR_Unit_Request_Table.CreatedDTM])=[dateorder]));

  2. #2
    Join Date
    Dec 1969

    Default Format wrong...

    ... And [dbo_TFHR_Unit_Request_Table].[CreatedDTM]=[dateorder]<BR><BR>You must put the [...] around each *piece* of the name, never around the period.<BR><BR>But, really, there is no reason to use [...] in any of that. You should be able to get away with just<BR> AND dbo_TFHR_Unit_Request_Table.CreatedDTM=dateorder<B R><BR>And none of those parentheses are ever needed.<BR><BR>I&#039;m not sure that&#039;s the only problem, but it&#039;s a start.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts