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
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
06:01 AM
Grimjack60
replied to a thread
Calculation Field in a Report
in
Reports
Yes, it is located in the Report Footer section. It is the coding I am having trouble figuring out. The first calculation field was easy. However,...
see more
2 replies | 68 view(s)
Today,
04:59 AM
skydivetom
started a thread
Need Assistance with Streamlining/Reducing # of Queries to Output "Percentages"
in
Queries
Happy Friday: I need some assistance with streamlining/reducing # of queries to output a "percentage query". Objects I Have/Need to Keep: -...
see more
0 replies | 10 view(s)
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 | 190 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
2 replies | 68 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
2 replies | 68 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 | 190 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 | 190 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 | 190 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 | 190 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 | 190 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 | 190 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 | 190 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 | 190 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 | 190 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 | 166 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 | 166 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 | 166 view(s)
05-15-2024,
11:35 PM
Welshgasman
replied to a thread
Forum problem?
in
Forum Suggestions
It has been quiet on other forums as well?
see more
6 replies | 166 view(s)
05-15-2024,
11:21 PM
davegri
replied to a thread
Forum problem?
in
Forum Suggestions
I emailed Matrix just before 8:30 advising dearth of posts. I saw he logged on, then emailed me that he saw nothing wrong. That's when I started...
see more
6 replies | 166 view(s)
05-15-2024,
09:33 PM
Micron
replied to a thread
Forum problem?
in
Forum Suggestions
Looks like at least you have permission. Let's see what happens now... :)
see more
6 replies | 166 view(s)
05-15-2024,
08:31 PM
davegri
started a thread
Forum problem?
in
Forum Suggestions
Just a test to see if the forum is allowing posting.
see more
6 replies | 166 view(s)
05-15-2024,
11:50 AM
isladogs
replied to a thread
msaccess.exe remains open
in
Access
UPDATE 15 May 2024 I reported the text cursor indicator as a definite issue about 10 days ago Yesterday I did some further testing and found 2...
see more
18 replies | 803 view(s)
05-14-2024,
04:14 PM
June7
replied to a thread
Creating Table from column data in another table.
in
Database Design
Access query builder has a wizard for CROSSTAB. It will help you learn and understand until you won't need it. Also review...
see more
9 replies | 482 view(s)
05-14-2024,
02:29 PM
Welshgasman
replied to a thread
Creating Table from column data in another table.
in
Database Design
That is when Google is your friend. :) Plus the wizard does it for you?
see more
9 replies | 482 view(s)
05-14-2024,
01:32 PM
Clifford86
replied to a thread
Creating Table from column data in another table.
in
Database Design
I do not know much about CROSSTAB query or how to even go about setting it up to achieve this.
see more
9 replies | 482 view(s)
05-14-2024,
12:56 AM
June7
replied to a thread
Changing image source
in
Access
I tested. The event triggers only when I click on record selector at left side of form. If record selector is inactive, no click trigger.
see more
14 replies | 459 view(s)
05-14-2024,
12:28 AM
CarlettoFed
replied to a thread
Changing image source
in
Access
Attach a sample file and everything will be faster.
see more
14 replies | 459 view(s)
More Activity
No More Results
No Recent Activity