Search results for query: *

That is something I've never heard of before... I'll certainly give it a try -- if I can figure out how to do it!! Could you provide an example of appropriate syntax?

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 knew it had to be simple. Thanks!!

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

After removing the master child month from the setup, I got the result I wanted. I haven't tried using a report to display the charts, and didn't even know it was possible.

This will be on a form, which uses a query that generates a summarized [Month] (such as 2009-05) and the six points of data [ATDays1], [ATDays2] ... [ATDays6].

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 just solved my problem just as you replied... I don't know if it's the most efficient, but it works, by using [Stats]![ATDaysAll] Thanks for all your help!

That is a great help, although I am now rethinking my approach to this, as it it now has been decided that only a monthly average is needed. I think this will (should) be easier to implement. To hopefully make this easier, the table that consolodates the data is "Stats", there is a [Date]...

As I expected, this would be a big function :) Can you explain the "Group By" and "Having" functions (as these are things I haven't used before)? And this is going to become an actual query?

Thanks for asking for the clarification... I realize this might be a bit difficult to get across. The key to this is that the data that I'm working with starts from the current date and works backwards. As I have daily data, I'm looking to get an average based upon the 12 cycles of 7 days and...

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

I would have NEVER thought of that, but that gets me to what I need. I'm going to try various versions of that to see how defined I can get, as I'll need to further drill down some subcategories. As an example, I'll need a subgroub where holding is true and Legal is false. As I understand it...

I may need this broken down to its bare basics, as I get an "Invalid Syntax" error when trying this process. Here is what I have for a query: ATDays: Avg(DateDiff("d",[NUI Date],Date())) WHERE [Holding] = -1

Thank you very much. That bit of information will help with this entire process.

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