How can I form a query that collects info based on the amount of times it
appears in the table.  I want it to return inspection number, inspector name,
inspection state where inspection number is in the table 3 or more times.  I
think it has something to do with count and ...

I know this might be a dumb question but I have 2 tables, 1 has a list of
name & the other is a table for competitions the various players have played
along with the winner and prize. I dont know how to do a query where I can
tell it to pull up how many games were played by each ...

I have been using Access2007. I have a list of queries that I would like to
be able to filter, and then get a report based on the filter.
When I manually highlight a given field in a table and hit the filter
button, it shows all of the options to filter by, and lets me check mark ...

How o I make a query so that I can count the number of "yes" responses and
have the query grouped per month - basically want to count the number of
"yes' per month.
ID=1

Good Afternoon,
How would I go about running a filter/Qeury that would give me results of a
field with no duplicates?
Thanks in advanced

I'm really stuck in the database that I have created.  I need to be able to
have a filter for a text field (example: filtering by name) but I really
don't know how to do this.  Simply filtering the table is not enough, seeing
as I need to have more then one filter going at the ...

I am running a query that grabs information from a field in a table.
That field can have numerical value or character value.
When it is numerical, it looks like 0000034567
I want to truncate the numerical to just the last 5 digits.

INSERT INTO [BACKORDER_SNAPSHOT_8_10_Cleaned up] SELECT
[BACKORDER_REPORT_072907 to 080407].* FROM [BACKORDER_REPORT_072907 to
080407], [BACKORDER_SNAPSHOT_8_10_Cleaned up];
The above query runs for 15 -20 minutes then returns error 3183 (Not enough

I have a couple of spreadsheets that use multiple lines for each record.
Sample follows:
Name            Address                     City        State        Zip
Contact

Here's the setup:
Two linked tables called 'PHD' and 'XANS' bring in daily data from two
CSV files.
A union table-query puts the common data in both into the same name

Hi, I am having a problem. I havw three tables:
Subinventories - Names and IDs of locations
ccfile - All my widgets, numbers, quantities etc.
[Check in Items] - Items I have scanned

Is there is an easy way to calculate a month parameter.  For example.  If you
have a date differance between a start date and end date and you want to know
the number of months inbetween.
Secondly.  Is there a way in a query or report to total all those who fall

I have a table in Access that has duplicate records.  I want to design a
query that will only show one instance of each duplicated record.  I have
tried many things with no luck...Please Help!!

I am trying to create a nested IIf statement in an Access 2007 query and
continue to recieve an invalid procedure error.  When I seperate the
statements it works without a hitch.  Any help would be greatly appreciated.
--------

Hi all, query solution I hope !
I have imported a csv address file into access : Address1 Address2 -
Address6
Some fields are blank followed by another blank