Search results

re Query to combine a date and a time Apologies for the lack of clarity. All the fields are set to date/time, but the formats are Short date, Medium time, and General date. Given this information, then how do I set up the cocatenation?

Hi, I am trying to create a general date field by combinging a date (short date) and time (medium time) field. The fields are named recDate and recTime for the two I am combining, and cmbDateTime for the result field. When I run the query, the result I receive is an errror stating that it...

Thanks, this was a start. I followed your suggestion and found that the missing reference was "shappmgr 1.0 Type library". I also searched the forum as you suggested, and although I found the problem mentioned a few times, nothing existed in the way of how to actually find the missing reference...

Hi, I am trying to run a query that selects all records for the current date. In one version of Office, it would work well with the Date() function. But in my Access 2002 version, the Date function is reported to be non-existant. So, I tried the Now() function, but obviously that relates to the...

Easily done! Thanks very much!!

Hello, I have an access query that I would like to have the user prompted for a date range to list records in a tabular form. The "Between - And " query works fine, but trying to get it to prompt for the range is something that either I am not grasping, or it is not possible. Any and all...