However, when I run the query I get the message "Data type mismatch in
criteria expression" If I hard-code the number of days, it works. Any
ideas. Thanks!
Re: Converting bad table design to good design ... There isn't really a whole lot to learn about append queries....query) they are queries like any other. ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... >>> Category for review... (microsoft.public.access.externaldata)
Re: DataAdd is giving a Data mismatch error ... By the way, even though the field is named [HireDate], there's no guaranty ...mismatch error message.... > I am running a query that returns the employee's review date using a ... when I run the query I get the message "Data type mismatch in ... (microsoft.public.access.queries)
Need help to structure simple (I think) query... ... For ALL the Reviews associated with a Document, there can be only ONE Review ... So I want to structure a query that will identify the Document IDs that fit ... but I want only the Document records where there is more than one ... I tried a crosstab query like this: ... (microsoft.public.access.queries)
RE: complicated question ... > review containing a record number and a date. ... > to populate the record number field on the second ... > form when it opens as well as another field not included in the query (but is ... (microsoft.public.access.forms)
RE: complicated question ... > review containing a record number and a date. ... > to populate the record number field on the second ... > form when it opens as well as another field not included in the query (but is ... (microsoft.public.access.forms)
