Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: emueller
  • Content: Threads
  • Order by date
  1. emueller

    Security issue regarding append/delete queries

    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...
  2. emueller

    SQL Null Query

    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...
  3. emueller

    Showing multiple months on a single graph

    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...
  4. emueller

    Generating Date ranges for graphing

    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...
  5. emueller

    Basic statistical query

    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...
  6. emueller

    Problems with security and mdw

    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)...

Part and Inventory Search

Back
Top