I have a table that has a street name field it contains an address like 123
Main St. I want to know how to make a query that would look for street names
beginning with "m."

I am using the Stephen Lebans / Peter Schoeders serialize function as line
counter in a query. Once I apply a criteria in the query, the line counter is
not updated with the actual lines.
What am I doing wrong?

I am attempting to generate a query using two tables that have multiple
relationships.  When I run the query, I know I should get some results, but
don't get any.  I will try to explain this as well as I can.
Table 1: Supplier Information

Ok so here is the problem....I am using Access to track the keys we issue to
employees from request to issuance to return. I have the employee fill out an
adobe form which then gets imported into access and populated into an access
form as well as my core access table. What I ...

I am attempting to create a running count within a group in my query
(using design view).  The goal is to time-zero the data so that rather
than a date with each data point, I have a running count on the number
of days of production.  E.g.

I am trying to complete an update query, this is my SQL:
UPDATE dbo_PROD LEFT JOIN dbo_DS_SKU ON dbo_PROD.[SKU Code] =
dbo_DS_SKU.SKU_code
SET dbo_DS_SKU.SKU_productname = [dbo_PROD].[Product Name],

I posted this a few days ago, but no one has replied yet.   If someone has
any suggestions that would be great.  I think the problem is with my coding
in the criteria section for calfbirthdate and entrydate.
Here is my previous post, thanks!

I have a ACCESS07 table that has a field called Unit, and another field
called Members.  Each unit can have up to 48 members, and there are many
units in the table.
I need to figure out how to do a select count to find out how many members

I am attempting to use Duane Hookom’s concatenate function without any
success.  I’ve read many threads, relating to Duane’s function, yet none seem
to fit my situation.
I am working with multiple tables, with a M:M ‘Joining’ table in the middle

probably a very basic question, but I am having a bit of a problem setting
up a parameter query.
I have access connecting via ODBC to an external database and returning two
tables. What I want to do is limit these tables by the project id field. Now

How can I make a query so that the criteria for the parameters are a drop
down list of the values in that field.  For example, if the field is "Country
of Project", the user can choose from the available countries via a drop down
list rather than enter in "Kenya" in the criteria ...

I can't remember how to convert columns into rows (I can do it the other way
round).
I have the following data:
ID    YEAR    PUPIL_ID    SUBJECT    DESCRIPTION

Have a SQL DB (MySQL), a table(tblUPL), a column in the table(CompanyName)
An Access2003 Frontend (OurWork.mdb). A form (ClntName) a field inside the
form (CoName), A passthrough Query (PTNameChng).
the query was orginally and Access Update query that changed

I am trying to create a query
that will show me all the records in
my qryZoneProcess even if there
is no match in my EMPInfo table.

I have 2 queries.  I comebined them but some records are missing.  The
situation is as follow:
Query 1:
SELECT Distinct PartNumID AS PID, Manu, POOutNum, PartNum, Quantity,