query based on query (3 Viewers)

MajP

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 19:28
Joined
May 21, 2018
Messages
8,556
The problem is you can only compare dates - the OP's field contains the number 6684676. In a comparison, you get this error
Click to expand...
No, you can compare any number to date. You have a typo with an extra "?"
date.jpg
 
You must log in or register to reply here.

Similar threads

B
PIVOT Tables
Replies
6
Views
485
June7
June7
T
Solved How to count distinct id?
Replies
5
Views
796
tihmir
T
D
Solved DatePart function error
2
Replies
30
Views
496
davegoodo
D
T
Querie Dilemma
Replies
8
Views
319
Pat Hartman
P
J
Automate mutiple append queries - use the Autonumber primary key from 1st query as input in 2nd
Replies
7
Views
407
Pat Hartman
P

Users who are viewing this thread

Total: 3 (members: 0, guests: 3)
Top Bottom