Dear Sirs:
We want to select all the data in a field that is of the date and time type, how can we do so that this selection maintains its same format. Any ideas?
Solved! Go to Solution.
Thanks for your help. I was able to fix it by placing the TEXT () statement so that it maintains its same format.
Are you implying that you have already gotten the information, but it is a different format? How did you do so?
Hello Marc:
I just did the following statement:
SELECT (Table [Select Field], true)
So what is the original data, and what is being returned?
For reference:
Thanks for your help. I was able to fix it by placing the TEXT () statement so that it maintains its same format.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |