Register
Help
Remember Me?
Forum
What's New?
Activity Stream
New Events
Mark Forums Read
Quick Links
Today's Posts
How to Post a Question
How to Mark Thread Solved
How to Attach Files
Advanced Search
Home
Activity Stream
Activity Stream
Filter
Sort By
Time
Show
Recent
Recent
Popular
Popular
Anytime
Anytime
Last 7 Days
Last 7 Days
Last 30 Days
Last 30 Days
All
All
Photos
Photos
Forum
Forums
Filter by:
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Yesterday,
02:42 PM
June7
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
You tried SQL statement I suggested? I tested against your sample data and it returns 1 record. I suggested removing time parts because I thought all...
see more
9 replies | 174 view(s)
Yesterday,
02:29 PM
davegri
replied to a thread
Calculation Field in a Report
in
Reports
Is the "bottom of the report" the report footer? If not, try it there.
see more
1 replies | 60 view(s)
Yesterday,
02:17 PM
Grimjack60
started a thread
Calculation Field in a Report
in
Reports
Hello, I have an unbound calculated field in my report . It determines the number of days between 'today' and the date in another field of the...
see more
1 replies | 60 view(s)
Yesterday,
01:41 PM
mike60smart
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
If you run the query I suggested then it produces the following result. If you also add Is Not Null to the criteria for Max date then the results...
see more
9 replies | 174 view(s)
Yesterday,
12:49 PM
pbDudley
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
Oh, I messed up., its tied to other tables that make the time field technically not unique, I forgot I tested it with just the columns that were...
see more
9 replies | 174 view(s)
Yesterday,
12:32 PM
mike60smart
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
Here is an example of query
see more
9 replies | 174 view(s)
Yesterday,
12:19 PM
pbDudley
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
Alright, I'm not even sure if this is enough of an example with the data but Ill try. Everything that I have is tied to the plan number, a form ...
see more
9 replies | 174 view(s)
Yesterday,
10:08 AM
June7
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
Your table is named "TABLE_NAME"? Domain aggregates will certainly work in a query and can build expression in design view. If you want to return...
see more
9 replies | 174 view(s)
Yesterday,
10:04 AM
Welshgasman
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
You can create a new db and import just what is needed? I doubt very much a date and time field is going to be confidential? Or you can obfuscate...
see more
9 replies | 174 view(s)
Yesterday,
08:52 AM
pbDudley
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
Ok, I see the DMax as a criteria option but I dont think Im writing it correctly, or perhaps it cant be used in a query design view But I have it...
see more
9 replies | 174 view(s)
Yesterday,
08:02 AM
Micron
replied to a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
I think you want to use DMax, not Max. EDIT - or a sub query. Seeing some data would probably be a big help.
see more
9 replies | 174 view(s)
Yesterday,
07:55 AM
pbDudley
started a thread
Trying to create a query that returns only the newest records based on one date field
in
Queries
Hello I have a query in access that can have multiple records for one unique id. Each time the record is modified, it saves that record. I do have...
see more
9 replies | 174 view(s)
Yesterday,
07:13 AM
Micron
replied to a thread
Forum problem?
in
Forum Suggestions
Maybe we can blame AI.
see more
6 replies | 152 view(s)
Yesterday,
05:54 AM
orange
replied to a thread
Forum problem?
in
Forum Suggestions
I noticed it seemed quieter than usual.
see more
6 replies | 152 view(s)
Yesterday,
04:58 AM
Bob Fitz
replied to a thread
Forum problem?
in
Forum Suggestions
I had also noticed the lack of posts and wondered...
see more
6 replies | 152 view(s)
More Activity
No More Results
No Recent Activity