I have a table with 3 date fields. At least one of them is always filled in, sometimes all of them. In a query, I need to return the single highest value of these fields for each record.
Does anyone have any idea how I can do this? It is starting to hurt my brain.
Many thanks,
James
I am not sure if this is the correct forum for this, but i was wondering how much i should expect to pay for a simple access db. I just want a customer one, shoowing what was ordered at each visit, how much each cutsomer spend, when they visited etc. Then reports could be done on how much is...
...well, being driven insane, anyway:
I have 2 databases, one on an networked drive shared by my department (P:\), and one on an networked drive shared by the whole company (S:\).
In my P Drive Database I have queries which will accept the Date() function, whereas the S Drive Database will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.