I would like to add a drop down list from data in a table to a query so when
the query is ran the user can use the drop down list to select an item for
the query to search by.
Thanks

After upgrading to Access 2007 (from 2003), I have a query that has stopped
working. It is something like
SECELT id
FROM [tbl names]

I have a database where one of the fields has multiple values (second column
PlanofRecord).  There could be only one or many values with that are the
same.
Ex:

I want to use a query to change a stock number field from 12345 to
"12345", but cant work out how to do this! Any ideas please
Alec

I am doing something wrong and I can't figure it out.
I have a crosstab that I am trying to set Null values to "Missing Value".  
Right now, the crosstab creates a seperate column and only shows "Missing
Value" if all columns for my data are null.  I need it to appear in each

I am running a update query that prompts you for user values and then updates
table "Shipping".
The value for "PO Number" will be prompted and then needs to be modified
before it is put into the table.  They will be entering in a 5 digit PO

I have a database with 5 different tables that were imported from Excel.  
Each table has the same fields, but different data.  All tables have the same
exact primay keys.
How can a run a query for all 5 tables?

Basically In does not seem to work in a paramter query. I would like to have
a parameter that asks the user to input a list of subject  numbers to
analyze. I tried using In , which works fine for regular criteria, but it
will only work if you only input one number. Can't ...

I have a table that I am trying to add an ID number into from another.   The
two tables have a Social Security Number that is the only way to link the
tables.  I am trying to change that
I am first doing a select query before the update query

I'm having a little dificulty using CDate in a  calculation between the  
start of the current fiscal year and now.
The query I'm using below works fine for someone using DD/MM/YY as their  
global date setting and produces a correct fiscal year starting Aug 1st of  

I have a query that I have built and in the query there are 2 tables.  I have
a "Team Leader" data field in each table.  I have made the relationship
between the 2 tables by using the "Team Leader" data field.  If I run the 2
tables seperately, it give me information.  When I run ...

I am trying to combine two IIf statements
Expr1:
IIf([tblItemListVendor]![PricePerLbOrCs]="Lbs",[tblCurrentPrice]![LastOfItem
Price]/16)

My UNON query is sying that it can't sort on this field.
[EmpFirstName] & "" "" & [EmpLastName] that this field isn't included.
The field is there.  What am I doing wrong?  This is in a report.
Thanks

I have a query where its possible to have up to 25 col of data at any giving
week. Can somebody walk me thru the steps in how I can create a Dynamic
query where it would report out on the datafields that are present in the
query. For example if I have

I'm having a problem with this UNION query.
The sort order is saying that it can't sort on the [EmpFrstName] & "" ""
& [EmpLastName], it says that it isn't included.  Also can I use Union
All as opposed to just UNION?