ver2507 bug
I got an Access 2016, it updated itself to version 2507 (build: 19029.20156). Since then I can't use the linked table management interface. I can't refresh linked Excel sheets. The Version 2507 (Build 19029.20136) was still OK, but I can't downgrade my Office 2016. Is there any solution?
Calculating Age In Access
Hi All, Just got a question regarding calculating ages in tables in access. I am on Access 2016, and I have two columns, DOB, and Death Date. I only have one entry for a death date, and if there is not a death date I want to calculate it from today. Would I use a Calculated Field Type? What would I put in it? I found some Vba code, but I don't know how to put that into my table.
MS Access Database Decommissioning
Hi folks, We have the following version of the MS Access Database and we are not sure when MicroSoft is decommissioning this version of MS Access Database. We have the latest version of MicroSoft Application installed as a part of our environment, but the actual MS Access Database is the following for one of the databases. Do we need to update this database called Pontiac to the latest version of database. The database itself is showing Access 2007-2016 file format - Access. Do we need to update this database to the latest version of database. We really appreciate your recommendations. Thank you
MS Access Forum Web Design Irritation
🙃 Can we take a vote and get a show of hands for how many MS Access Forum users find the little social media bar on the side of the screen not only unnecessary but also an annoying waste of virtual real estate? 😉 Any chance the site admins could reconsider the location of that annoying little intrusion to possibly find someplace else to try and recruit new members to your OTHER social media outlets? 🤣 A wise old saying that so many members of the current human population seem to have forgotten or never learned is, "Just because you can do something, doesn't necessarily mean that you should." If more people understood those words I would not be here right now typing these words... 🤪 LMAO Have a wonderful day everybody!Distinct Count Subquery, MS Access
Need some help in getting a Distinct Count result in this query. For context, i work in healthcare and of course an not share the actual data behind the query. My goal is to modify the current quiery - which returns total charges by account financial class (medicaid, commercial, medicare, sellf pay) and account date within a given month (post date, in the query), but add on a distinct count of hospital accounts in the grouping. Current SQL below, all data lives in the ez_hosp_chg_v. table. End goal is to return a distinct count of the bold/red data point: "HOSP_ACCT_ID" SELECT ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, Sum(ez_hosp_chg_v.ORIG_AMT) AS SumOfORIG_AMT, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID FROM ez_hosp_chg_v GROUP BY ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID HAVING (((ez_hosp_chg_v.POST_DATE) Between [enter start date] And [enter end date])); I've attempted incorporating a subquery like this distinct count example, but can't get the syntax correct in my version: source: https://www.access-programmers.co.uk/forums/threads/count-unique-values-in-a-query.327614/ Any help or pointers are appreciated. -Joe
Report Generation
Dear Experts , I am Kind new to access I Have been working on this project for few weeks now and I am stuck . as you will see from the attached file , I have a data entry form who enters data into "Data" table . the table has 22 columns , but for report generation I am using only few columns as filtering criteria ( Visit Date, Gender ,Age Group, Group ,Visit Type and Diagnosis). when you look at the report form you will notice its a matrix table composed of diagnosis columns and 12 other columns comprising the criteria for filtering, and also 2 date textboxes for start and end date and a command button to trigger the counting process. I want you help in : 1- report generation by counting the number of each diagnosis against each criteria and display the result in the specified textbox ( for example , the No of malaria cases who are " GPOC", :Male" ,"New Visit",">=5" . and finally calculate the total at the end (See report).
