I have the following query:
SELECT     dbo.qry_UV_CARS_PlateX_ShouldBeValued.Yl_iD
FROM         dbo.qry_UV_CARS_PlateX_Valued RIGHT OUTER JOIN
                     dbo.qry_UV_CARS_PlateX_ShouldBeValued ON

From a select query results, use copy command, pasted in excel - memo fields
do not contain all the text that database has. (database had 409 characters).
Also tried Tools - Office Link from menu to create an Excel file; same
results. Any suggestions?

I would like to be able to avtivate a query on a specific date

I found some code that will concatenate some values from a table into
a single string, and it works but only under certain conditions -- I
am stumped as to why.
The code I found: (at http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx):

I have designed Databases for many years now, but never attempted this:
I need to know how to create an email with information located in the active
form or off of a query. I would like to have the email automatically
generated with the To Address, The Subject Line and the Body ...

Ok here it goes bare with me.
I have a 4 tables
Tbl 1 (basic inform)
Exihibator ID               Name               Etc

I have a table with grade records for students where a particular
subject might have several grades entered on different dates. I only
want the latest grade, plus other stuff like AdNo, name and gender.
Using code found here sort of works but seems to miss out some subjects

My multi-user database is on a server and I experience different query
results depending on from which workstation the query is run.
The query converts a txt-field into a date format with the following
command: format([left([variable xyz],16,”General Date”) with a criteria of

My data includes 3 scores, then I have a query to add those scores together.
Data
Entry #     Performane Score 1     Performance Score 2  Performance Score 3
Query

Ost  Ocity   Dstate  Dcity  Carrier  Price  Rank  Diff
A      B          C         D       X        1200    1       100
A      B          C         D      Y        1300    2        100
A      B         C          D       Z        1350    3        100

I am getting a TYPE MISMATCH error in the expression of the following
statement:
PrevAdj:
IIf([qryProjectLineItems.BMNo]=1,0,DSum("Amount","qryBMR","qryProjectLineItems.CostCode='"

I'm putting together a database to collect and record when employees of our
various project sites complete and return certain forms to us. What this
means is that several sites will potentially have more than one date entered.
I've created a table called "site number" and date ...

I began trying to make a query that would use information based off a filter
query, w/ the goal of creating a report from the new query. To open the
report i created a macro and  than tried to execute it.
Thats when i got the followig:

I’m trying to run an append query from a stored procedure which fails. I’m
moving data from one table that has duplications on the primary key of the
second table. With Access, an error will be generated saying that ‘cannot
insert so many records because of key violations, do you ...

It there anyway to have a list box in a query? For Ex. in the Criteria box in
order for a msg box to display you have to enter [] then you can "type" in
what you want it to search for. My question is can I have a drop down box in
that Messagebox?