I have a query that averages values for several sets of categories. I am able to average with a null value in each category, but if the entire category has a...

Greetings, thank you all very much for taking a look at this question. The situation is that I am comparing spend with suppliers from one year to the next. ...

this is the scenario: the user will enter a DU# that will then pull up a form that's linked to a query that searches thru a table using that entered "DU#"...

I have the following query. Sites Date Circuit Status Num PNE038 11/20/06 22:01:03 x25CircuitDown - Critical ...

Hi, I have the following situation, I have a linked MySQL table which is populated, and a blank Access table whose schema matches the MySQL table as closely as...

Well, since the object field can 't be used in word anyway, try building a query that excludes that field.... -- Albert D. Kallal (Access MVP) Edmonton,...

Using the wizard I compare two tables using the social security number as the join field (primary key in both tables). The query does not find all the...

MSAccess 2003, Windows XP Pro, MDB front end, Sql Server 2000 Back End I would like to pull statistics from several fields (AUDITDATA, LOGINDATA,...

I have attached a query with a sub query (created by the query wizard). I have a Date, Start Time and End Time as the matching fields; however, I want the...

This is actually a post from some months ago. I still have this problem and would like to have a fix for it. You have to read the bottom post first then read...

Hello, I am connected with view only access to a SQL database. I am running my queries needed through access. The dates/times in the SQL database are...

I have a query that searches for records by the month. I want create a further sub set of the query by the AgencyID. I created a table join so that when I...

I'm designing a database so i can keep track of queries at work... I have designed it but I want queries that are over two days old to be escalated there is a...

I need to build a Db that I can "Import" excel reports to check for dups. in the "SKU" field. Can I build a generic query that I can put on a form after the...

I have this database which lists part numbers and their distinct serial number (1 part number could have multiple distinct serial numbers). I need to count...

I have a Microsoft Access 2000 database that I converted the back-end to SQL server 2005 and kept the front-end same. Is there any way I can hide the pop up...

I have a database of graduate students that uses their SS# as the primary key in the main table, and as a foreign key in the related tables. I have enforced...

Hi, I've produced a linked database i use for validation of records entered into a database that are incomplete (ie. contain blank fields). I've produced a...

I need to convert an all uppercase sentance to a easier to read "proper" case. The StcConv(,3) doesn't do what I want because it does every word in the...

I hope somebody could clarify this for me and point me into the right direction. I think most of people are familiar with a concept of stacked queries, they...