how can you split the datetime stamp in the query its self? I thought there were function commands you could use? If so how do you use them?
-
-
you may have to build the query string itself (see an example here) such programing isn't for the faint-of-heart. The level of control you will have over the data will be very dependent upon which version of Office/Access/Excel you are using.
IMHO; you will find it much easier for you to build the appropriate fields in the record source you are using first and then link into them via MSQ
Comment