Hi, I am new to MS Access, and I cannot figure out how to perform the
following queries:
What songs by Norah Jones are currently in Car?
Which location has the least number of files? How many?

My query gives me this
  Date1         10        9       8       7
  Date2         20       10      5       1
  Date3         30       25      3       2

I have a table that basically holds a start time and an end time for
an event. Now I want to generate a report that returns all events
sorted by time, whether something starts or ends.
Table  StartTime   EndTime   Event

Can someone help me with this query?
What are your friend’s top three favorite artists? Query should only return
3 artists.

Like IIf([Forms]![Purchase Orders(inventory)]![LookFilt1] Is Not Null,"*" &
[Forms]![Purchase Orders(inventory)]![LookFilt1] & "*","*")
If LookFilt1 contains a string the filter works and displays all records
containing the string.

I have a problem in that one data field does not show up in a cbobox
RowSource even though when I run the SQL for the RecordSource it works just
fine, but it does not show in a cbobox or even a listbox. When I drop down
the cbobox it's like it knows the amount of records that it ...

I need help making access give me a combo box when i run the following query.
Right now, it just asks me for the two parameters...I want to be able to
select them from a menu.
SELECT [Tbl Main Serialized Parts].[Line Number], [Tbl Main Serialized

I am trying to get initials from a generic [Name] field - is there any way to
accomplish with a function?  The field stores company names so if it had
Allied Waste Services in the field I want to return AWS.  
Thank you

Select DISTINCT No_, [Dimension Code],
[Dimension Value Code]
FROM [TOC$Default Dimension]
Where [TOC$Default Dimension].[Table ID]=18 AND [TOC$Default

can't find proper criteria syntax to select "1958 dog red" in a field which
could have additional text, for example "1962 cat brown 1958 dog red 1977
airplane"
Seems simple but can't come up with anything that is accepted or produces a

I have a crosstab query that runs.  It is based on employee time,
Employee       1/1/2007    1/2/2007    1/3/2007..........
Doe, John          x               x                x
Doe, John          hol            exc             sk bank          

I am trying to figure out a way to tell how many consecutive days there is a
schedule entry for a person in a table. I've set up a query to yield a
person-day combination to filter out entries I don't want and the resulting
query is called qryDateProjectPerson with fields ...

I am trying to build an append query to add a certain number of
records to a table based on a number I enter into another table.
Detail:
I have a table that will track loan information "DebtMain".  In this

I want to create a query that would look at the table, and see which records
are not in the query, and display them in another query.
Table A = msd
Query A = records extracted from msd, distinct records

Overview: I have 3 queries searching 3 different tables for 2 fields.  I then
have one combining query that adds the results of the 2 fields from the 3
queries.
Each query finds records in the table that match a particular date.  When