I just completed normalizing my database after getting my head around the
information that needed to be inputted.  Now I am creating a number of
reporting options but I think I am reaching the limit of the query size and
am looking for alternative solutions.  

I need to something like this
initials: left([First_Name],1) & left([Middle_Name],1) & left([Last_Name],1)
I have a 'Designers' table that has a drop down to pick people from an
'Employees' table to be designers. What I need is to automatically generate

I want to pull a query but I have 300+ individual items to pull.  These are
part numbers.  I do not want to type them into the criteria row one by one.  
How do I accomplish this project?  They are currently residing in an excel
spreadsheet.  Can I export them into Access as a ...

Good afternoon,
I have a question problem that I can't seem to solve. It primarily regards
the usage of "and" and "or".
I have a table that looks like the following:

I have a report that is formatted to look like a crosstab that includes rows
even if there is no data for those rows.  Suffice to say, I am using the
expression listed below to populate the report's fields.  When I run the
expression with static values it works fine.  However, ...

I have a list of choices in a field on a form that I want to pass to a Query
and use and IN statement to select.  I keep getting no records returned.  
Here is the SQL:  SELECT Attendees.AttendeeLastName & ", " &
Attendees.AttendeeFirstName AS AttendeeName, Registration.StartDate, ...

following SQL query results with Type Mismatch:
strSqlU = "update t_upisnik  set t_upisnik.bodova = SELECT sum(bodova)as
suma  from t_prijava where t_prijava.nepogoda = t_upisnik.nepogoda and
t_prijava.kultura = t_upisnik.kultura  " & _

How can I extract a portion of text from a text string using a query
Examples :
15 Rose Cottage Kent
15 Great Andrew Road London

I have done append queries before, though not recently, so I may be
doing some very simple error to which I am oblivious.  I am using the
query window.
When the query I wanted to do ran into Key Violation errors, I

For whatever reason, 7 years ago when setting up my main table, I have made a
field "SetterCompany".  It has has names like <John Smith; June Brown>
There is no way I can go back and change this field, after hundreds Queries
and 10+ forms

I'm using Access 2003.  I have a query that returns results, but it also
pops up a "syntax error in FROM clause" message.  I must have changed one of
the tables or queries it uses without updating the query, but I am not sure.  
I would like to open the query in Design or SQL View ...

I don't know if anyone can help me with this or not but for no obvious
reason a query will sometimes totally clear itself and will either have to
be re-written or restored from a backed-up version.  When I say 'cleared'
what I mean is that the query still appears on the query ...

I have a simple query..  no joins...  one table     CAN I create a field in
the query that will sequentially number and display  (temporarily each time
qry is run)    I don't need to manipulate it... just see it.
tx

Hej allihop nu har jag suttit i flera dagar och försökt skapa en fråga där
jag i en databas med kontaktpersoner deras adresser samt vissa av dem har
även e-post. nu har jag skapat en fråga för att få ut e-post adresserna men
jag skall dessutom ta ut kontaktpersoner med deras ...

I am writing SQL statements in MS Access 2000.  I would like to "comment
out" a statement.
 /* sql stmt */     does not work.
Preceeding the line with -- (two dashes) does not work either.  How can I