I get the following error message --
Undefined function '[Forms]![CTK_Assigned]![Combo23].Column' in expression.
 when I use this in  a query --
Expr1: [Forms]![CTK_Assigned]![Combo23].Column(0)

Hope someone can help me with this. I'm trying to simulate the results
from full outer join in Access across 3 tables using a union query
that someone recommended (or another method if it can be done):
--TABLES--

I have 4 tables, each shares Date and Service, but after that they vary from
budget details, to capacity details, all the way to actual details.  Since
the budget details go out into the future and the actuals do not, I want to
produce a worksheet showing data from all tables ...

table info:
Alaska    $1,200  Product A
Alaska        300  Product B
Alabama     900  Product A

I have 2 tables I am trying to pull data from and am only getting one set of
data.  table 1 has primary key of palletno.  There is a pallet of product
produced and there is 1 sometimes 2 referenceno for each pallet.  Each
referenceno is in table 2 that has fruitid as a primary ...

Hi, I want to set a field equal to a field in another table where two fields
match (if that makes sense.
Project Number is Text, Month is Integer, Cumulative Total and Total Order
Value are Currency

I have 2 excel sheets that I import into Access. They look like this
Table 1
92    DVD's & Video's    Dvd- Zipper Pulls    6-00104    49.99     
92    DVD's & Video's    Dvd- Making Turk's Head Bracelet    6-00103    49.99     

I have a SQL like below;
SELECT TOP 10 Format([Date],"mmm") AS [Month], Format([Date],"yyyy") AS
[Year], [DC Fan Information Centre].Model, Sum([DC Fan Information
Centre].Vibration) AS SumOfVibration INTO [The Worst 10 by Reject Item tbl]

I have a toshiba satellite 105 laptop computer that I bought in Decenber with
windows XP and I was running office 2003 stuent and teacher edition on it,
but after I installed the vista home premium upgrade as a full installation,
I can not get the CD drive to read the CD rom.  I ...

I get this message when I try to exit Access. It won't let the database close
- only way I can close it is through the tack manager possibly losing last
entered data.

I am trying to deal with the limits on updating fields in queries.
So, in a form that shows data re orders waiting to be shipped, I'd
like to be able to doubleclick on the order_ID number field (let's say
order # 02975) and have that cause a related form or table to open at

Is there anyone who can help me? I would like that the output of a query is
placed in a text field of a table. E.g. the output of a total query shows 3
records as result.I would like to combine these 3 records into one single
text field. How can I accomplish this.The Dutch ...

select FROM, query 2 kontaktperson, adress, postnummer, ort
delete from query 2 if kontaktperson+adress+postnummer+ort+e-post
to translate this into a korrekt string for access

I need to create a query that compares data in 2 tables.  If the data exists
in one table but not in the other, the query should take those exceptions and
put them in a new table.  Any ideas how this should look?

Is there a function in Access I can use to find the Median of a field?  
All I can find in the help menu are things like avg, min, max.  Not finding
anything about the median