Re: Date Format problem in parameter query

Aaron, it sounds like Access is confused about the data type of the field.

1. Are you applying this on a calculated field?
- Yes: wrap the calculation in CVDate()
- No: when you open your table in design view, what data type is this field?

2. Declare the parameter, so Access understands it correctlly.
In query design view, choose Parameters on the Query menu.
In the dialog, enter something like this:
[Forms].[Form1].[Text0] Date/Time

If that does not solve the problem, post the SQL statement from your query
(SQL View, on View menu.)


--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<aaronk23@xxxxxxxxxxx> wrote in message
news:1132268834.508096.102840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>i have a simple query that references a text box on a form as a
> parameter. the text box holds a date and uses the Short Date format for
> its Format property...nothing fancy
>
> when i try to use it in my query it returns no records (when i know it
> should). the really weird part is the date/value that returns from the
> text box is a wingding character or a box (looks like a 'hard return'
> character).
>
> if i turn off the formatting, it returns the value in the text box.
>
> i have tested this on several computers w/ the same results. what's
> more, i have done this sort of thing many times in other db's and never
> seen this before.


.

Relevant Pages

  • RE: Criteria in calculated field - unexpected prompt for input
    ... My data type mismatch error is occuring when I enter a criteria in the ... calculated field that uses the function Datediff. ... but not in the same query that created them. ...
    (microsoft.public.access.queries)
  • RE: Criteria in calculated field - unexpected prompt for input
    ... My data type mismatch error is occuring when I enter a criteria in the ... calculated field that uses the function Datediff. ... but not in the same query that created them. ...
    (microsoft.public.access.queries)
  • RE: Criteria in calculated field - unexpected prompt for input
    ... My data type mismatch error is occuring when I enter a criteria in the ... calculated field that uses the function Datediff. ... query whether I enter a criteria on not - *and* I cannot set the format back ...
    (microsoft.public.access.queries)
  • Re: EXPORT TABLE TO TEXT FILE
    ... Why the data type for doubles were aligned to ... Not when exporting a table. ... calculated field that does it for you, and export the query instead of the ...
    (microsoft.public.access.externaldata)
  • Re: Make Table Query-Issue with Date
    ... to instructions contained in a format expression." ... > When I run the query and it creates the table the Data Type is set to Text ... > selected and then opens charts based on the Make Table but since the Data ...
    (microsoft.public.access.queries)