![]() |
MS-DEFCON 2:
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it.
|
-
How to find the most recent transaction date of a unique item
Home › Forums › AskWoody support › Productivity software by function › MS Access and database help › How to find the most recent transaction date of a unique item
Tagged: 2016 Access, calculate date, Most recent date, MS Access
- This topic has 3 replies, 3 voices, and was last updated 2 weeks ago.
Viewing 0 reply threads-
AuthorPosts
-
-
January 26, 2021 at 4:56 pm #2337929
WSgarcich1
AskWoody LoungerMS Access 2016
Hello! I have an access table that records dates of a transaction and I’m trying to create a single query that will show the most recent date of a specific transaction. I cannot give the exact details of what my data – so will try to explain what I’m trying to doing with other examples:).
Say I have a table that lists dogs and a record of the date they had a bath. I need to maintain the historical record of the dates they had a bath. So I have Spike, Jaws, Princess, Thumper, and Buster. Each of them have multiple date entries of each time they’ve had a bath. I also have Tiger and Piglet, but they don’t get their baths with us anymore. So- they’re not active customers. I cannot delete their historical bath dates.
Is it possible to create a query that my boss can pull that will show each current customer/dog and the most recent date that they had a bath? And then – is it possible, in that same query to calculate what date they would be due for a bath again…say 30days from the date of their most current bath date?
Thank you in advance for any help! And thank you for playing along in my make believe scenario!
-
-
AuthorPosts
Viewing 0 reply threads -
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments. Click here for details and to sign up.
Search Newsletters
Search Forums
Recent Replies
scoobydoo on Frys electronics is closing
4 minutes agoKathy Stevens on Frys electronics is closing
26 minutes agoKathy Stevens on Frys electronics is closing
29 minutes agoBATcher on Is IT Skill Set Sustainable?
35 minutes agoKathy Stevens on Frys electronics is closing
39 minutes agoSusan Bradley on Custom plug in for moderators
39 minutes agoSusan Bradley on WordPress update 5.6.2 available
40 minutes agoSusan Bradley on Added a search box for posts and newsletters
40 minutes agoAlex5723 on USB Mouse Causes Laptop Black Screen
1 hour, 5 minutes agoMoonshine on Transparent content in dragged window
1 hour, 7 minutes agoPaulK on Net Neutrality is Dead ?
1 hour, 32 minutes agoLHiggins on USB Mouse Causes Laptop Black Screen
1 hour, 35 minutes agoAlex5723 on Windows 10 Feature Experience Pack 120.2212.3030.0 (20H2 &21H1) released to Beta
1 hour, 35 minutes agoanonymous on Frys electronics is closing
1 hour, 55 minutes agoStill Anonymous on Frys electronics is closing
1 hour, 57 minutes agoMicrofix on Can a swapfile be put on an SD card?
1 hour, 59 minutes agoscoobydoo on Frys electronics is closing
2 hours, 6 minutes agoCharlie on Can a swapfile be put on an SD card?
2 hours, 7 minutes agoscoobydoo on Large Norton Update
2 hours, 15 minutes agoopti1 on Bleeping computer reports Flash patch force installed
2 hours, 17 minutes agoWheeler on Spontaneous shutdowns
2 hours, 17 minutes agoStill Anonymous on Glacially slow, 10-minute boot times!
2 hours, 18 minutes agoMicrofix on Profile Picture Gone
2 hours, 21 minutes agoWheeler on Spontaneous shutdowns
2 hours, 24 minutes agob on New computer setting up – ‘Apps’ disappeared from Settings
2 hours, 42 minutes agoanonymous on New computer setting up – ‘Apps’ disappeared from Settings
2 hours, 44 minutes agoMichael432 on Surf the Web — even when your ISP is down
2 hours, 44 minutes agorebop2020 on Frys electronics is closing
2 hours, 45 minutes agoMichael432 on My Windows 10 Local Backup Software Choice, and Why
2 hours, 54 minutes agoGeo on Frys electronics is closing
2 hours, 55 minutes ago
Recent Topics
-
Medical ID on iPhone… WTH Apple?
37 minutes ago
-
Is IT Skill Set Sustainable?
36 minutes ago
-
Apple’s M1 iMac & Mac Pro Mini Exclusive leaks!
1 hour, 53 minutes ago
-
Large Norton Update
2 hours, 15 minutes ago
-
Transparent content in dragged window
1 hour, 7 minutes ago
-
raid config broken now only one drive visible
4 hours, 7 minutes ago
-
USB Mouse Causes Laptop Black Screen
1 hour, 5 minutes ago
-
Windows 10 Feature Experience Pack 120.2212.3030.0 (20H2 &21H1) released to Beta
1 hour, 35 minutes ago
-
Office365 colors
4 hours, 45 minutes ago
-
Frys electronics is closing
4 minutes ago
-
MS Edge Webview2 Runtime Installed?
9 hours, 11 minutes ago
-
Looking for graphic equalizer for Windows 10
11 hours, 18 minutes ago
-
Can a swapfile be put on an SD card?
1 hour, 59 minutes ago
-
Dm to bradley
18 hours, 10 minutes ago
-
Starting up my Chromebook
1 day, 9 hours ago
-
Veeam now working with kernel 5.8 in experimental branch
1 day, 18 hours ago
-
Microsoft changed my local account to a Microsoft Accountt
1 day, 3 hours ago
-
“Unwelcome” Open Windows Display
1 day, 22 hours ago
-
iOS 14.5 makes it harder for hackers to develop zero-click exploits.
2 days, 3 hours ago
-
New computer setting up – ‘Apps’ disappeared from Settings
2 hours, 43 minutes ago
-
Ver 2004 Update – Device Updates help
1 day, 19 hours ago
-
can not create new folder
2 days, 1 hour ago
-
All Browsers Fail!
1 day, 3 hours ago
-
How to create a bootable macOS installer
2 days, 9 hours ago
-
How to create a bootable macOS installer
2 days, 13 hours ago
-
Amazon’s new ‘same-day nodes’ will displace postal deliveries
9 hours, 50 minutes ago
-
Glacially slow, 10-minute boot times!
2 hours, 18 minutes ago
-
The latest vulnerabilities in the network stack
12 hours, 56 minutes ago
-
Freeware Spotlight — FastCopy
2 days, 11 hours ago
-
Linux Mint developers call Users to update their systems
19 hours, 21 minutes ago
Search for Topics
Recent blog posts
- Frys electronics is closing
- How to create a bootable macOS installer
- Amazon’s new ‘same-day nodes’ will displace postal deliveries
- Glacially slow, 10-minute boot times!
- The latest vulnerabilities in the network stack
- Freeware Spotlight — FastCopy
- Changes to policies
- Tasks for the weekend – February 20, 2021 – it’s Squirrel away time
Key Links
Copyright © 2004 – 2021 AskWoody Tech LLC. All rights reserved.