I have a table with the following columns: country, topic, company and name
(of people).  I need to count the number of topics per company.  For example,
if there are 4 people who worked on one topic from company X, then this
should count as 1 (and not four and the fucntion Count ...

I have a set of queries which each has 6 or 7 fields. They are being exported
to the same spreadsheet but one query is throwing up this error.

I am trying to create a "Totals" query based on another query. The source
query has a set of calculations between dates and I want the "Totals" query
to give me the number of records grouped by time taken (basically a frequency
distribution).

how do i have a query that displays information via the totals of each week
than each day (i am thinking that i would have to have multiple "step"
queries to acheive this)
eg:

Here is what I have put together.  Can someone tell me what I did wrong?  I
am not getting any errors, but it is pulling all records instead of just what
is "out of spec".  I need to pull what is out of spec for the product code
listed which is looked up in the tblProductSpecs ...

I have a query that joins a table to a SQL view (odbc linked to .mbd
frontend) and would like to update records in the table. Because of the join
to the view, the query becomes non-updateable. How can I get around this?

I have a text field column in SQL 2005 that contains HTML code.  I
would like to update certain references in this HTML code throughout,
but am having problems.  I know that I can't do a string replace with
the text data type, which is why I would like to cast it as

I'd like to count the occurnece of each day of the week within a date range
from 2 controls on a form.
form name = MainForm
control 1 = DateStart

I have queries that work fine on a W2K box with A2000 but when I run them on
XP with A2003, they don't work properly. All the data does not display. I
tried converting the database and it seems to work but no query results. I
used another copy, unconverted, and still no results. ...

We all know that Dcount doesn't support DISTINCT in VBA and there are
lots of threads talking about it everywhere.
But now I've found the way to do it.
We can use the criteria string to compare results.

i am working on a parameter query that checks a date range (using
Between/And) but that would return a patient name if no records were found in
that date range.
Any help is much appreciated...sorry, I posted a similiar question but can't

I have data that is in a text format for employees that includes birth date,
hire date, termination date, etc.  The date format is text and is written
YYYYMMDD (i.e. 20070719).  I have used the CDate to convert, but get data
type mismatch when I try to connect it to a Pivot table ...

I have this query that works great. It shows me which stores are buy a
certain product based on the product number.
My Problem is same reasoning however I want to know which stores are NOT
buying the product. I have tried using Null and I get nothing. Here is a copy

What criteria would I use to limit my results to include only records that
come up a certain number of times? I'm trying to limit my results to include
records that are in a particular text field at least three times.
Thanks.

Is there a digit wildcard in ANSI 92?
I need an alternative to "*#*"
I tried "%[0-9]%" with no luck...