Date/Time field as part of "Duplicate" query

[Guest]

I have a "duplicate" query that runs based on 3 seperate fields. The fields
are a core number field, a date field and a time field.

The XML data is imported in by a windows service. The reason for the
duplicates is they enter the program on a website and it e-mails the XML and
they call in and we reenter it prior to the XML being received.

My probelm is, when I run the duplicate query it matches the core number,
the date & the time and returns our results. But, the service when importing
a time only in to the Time field it creates a date?? The date is the day of
the import. How can I stop this???

The developer is saying this is done in Access 2003 and there is nothing he
can do??? What I don't understand is he can import a date in to a Date/Time
datatype filed and it only creates a date. Why can't he do the say with the
time???

Does anyone have a suggestion... I had numerous suggestions to use the
TimeValue function but it does not work with a duplicate type query??

HELP!!!!
Thank you
Tim T

 

[Jeff Boyce]

Tim

You've received the same answer from a number of responders, and it sounds
like from your developer, too. It may not be the answer you want, but it
answers your multiple posts.

Access does not have a "Time" field data type. Perhaps you need to consider
putting the "time" data in a different field type, like integer.

Or better still, since Access does have a Date/Time datatype, maybe you
could combine the two pieces of data into one Date/Time field in Access?

Good luck

Jeff Boyce
<Access MVP>