Hi, all!
Some error drives me nuts...
I have some code which gathers query names to run to the collection of
strings. Then I just run through the collection and use the

I have an Access front end to a SQL Server 2005 database using ODBC linked
tables. There appears to be a problem when using the euro symbol in queries.
SELECT *
FROM tbl_Datatable

I'm generating a pie chart using the output of a query. In the Design
View of the query, I selected the field containing the distribution
and set its Format property to "Fixed" and Decimal Places to "1". When
I create my report, however, these properties are ignored and I get on

We are wanting to run a query that lets users input either (eg >10) or two
numbers using the between/and function.
However when we use between/and, it doesn't exlude negative numbers for some
reason, and when we use a simple parameter, and type in >10, it doesn't

I have two tables:
tbl_Street_Joiner_Main
tbl_Street_Joiner
I want to add a new field that is a sequential record order number for the

I make up a query that consist of 20 fields. After i run the query and print
it out, I go to some of the fields and circle all the ones in that column.
Then I go to other fields and circle all numbers over 400 in that column.
Then i may go to another column and circle all number ...

I have been using this query:
SELECT table1.Name, table1.activity, table2.wann
FROM table2 INNER JOIN table1 ON table2.id = table1.id
WHERE table2.week = False And myDate = DateValue(" 22.11.2007 ") And

Problem:  When I have a run a select query (with fields coming from multiple
tables all joined), I frequently cannot modify/edit the contents of a cell.
This never happens when I'm using a query with fields from a single table.  
So I don't understand at what point the complexity ...

I am importing a table from excel in which my customers first and last names
appear in one field. I want to split this filed in access so I can sort and
search by first name and last name. Help..............

Not sure what this means:
 What must a union query have in order to bring two or more queries
together?
Anyone know?

I have 2 tables with each 2 fields, one of them is common. This common
field lets call it 'Currency'  contains values as AUD, USD, JPY, EUR.
In case 'Currency' matches for both fields I would like to multiply
the corresponding value for that currency by the corresponding value

I have developed qryQuickLook that brings up rptQuickLook when
cmdQuickLook is clicked, everything works great but I would rather see
the results (never more than 10 line items) in a MsgBox than have a
seperate report window open up.  Is there a way to do this?

Got a table look like this:
Time   UNITS
8:00    10
9:00     5

HI...Let's say I have 2 tables, tblRangesA and tblRangesB, each with
just one field 'RangeName'.
I know tblRangesA contains 5,110 distinct values, and tblRangesB has 6,008.
How do I construct one query, based on both tables linked on 'RangeName,

I have crosstab  querry that show  the max amount of each product sold for
the month.
How do I do a querry that will show the product that had the highest value
only?