I have a network database with an archive table of records that are transferred and no longer in use. Aside from the Administrator, I only want those in the "Screening" group to be able to append records from the Active table to the Archive table.
The process involves two tables (Active and...
I am working on a query that calculates a the average of the difference between two dates.
The issue I am having is that there are some pieces of occasional data that can severly skew this average, so I don't want to include them. So I would like to have the query ignore data where the field...
Thanks to some excellent help here, I have generated the data I need... now I'm having issues displaying it correctly.
My data to be graphed averages data for the month into six categories. I'd like to be able to create a bar graph that shows each month's data, but shows each month on a single...
I'm missing some small piece of my puzzle to solve this issue.
I currently have a database that tracks an average number of days on a daily basis for a number of parameters when the database backs up. These daily statistical numbers archive to a table, along with the applicable date. So, for...
If I can break through this initial problem, I should be on track to complete my project... but my Access newbie thought process is not helping me!
Here is what I'm working on doing. I am trying to make a query that will average the number of days to complete a process for records in my table...
Why is it that security in Access can be such a problem?
My database is (was) set to allow users access to section that they needed to see through a switchboard of forms. All was working fine... until a problem with the security.mdw file (which if I could pinpoint, I wouldn't be asking here)...
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.