Can you help me build the right IIf field in the query with the following
conditions :
The field DDU consissts of :
DDU :[exworks]*2+0,4+0,01

I have a series of parameter queries, with the brackets on the criteria line
under a field  [  ]   so that I can search out a record(s) of interest.
I am attempting to do so on a Yes/No field but it doesnt want to work.
What would be the correct method to set up a query so that I ...

I have a table that contains the following data:
Field1   Field2  Field3  Field4  Field5  Field6  Field7    Field8
Field9    Field10
(null)      H        (null)    SLD    (null)   next     1/11/08

I have a data table which has two sets of text with a space separating them.  
I need to remove text left of the space and place into a new field.  I'm
finding the count of characters to move using InStr function, but how do I
then delete and move to a new field??

I am using Access 2007 and have a question about a query.  Currrenty my
query prompts for a beginning date and an end date that the user has to type.
Is there a way to make the prompts a "date picker" rather than have the user
type numbers and dashes?

I have a source table as follow:
Unit        Provinces    Partners
Admin    P1                AA
Admin    P1                BB

im new to the world of sql, so im not sure if this is can even be
accomplished in a single query or if two separate queries are required.  i am
trying to put together a query where the end result is based on a condition
of an aggregate...i want the sum of the amount billed (and ...

I have to find the first occurance for data that comes from four fields.  
1. PO Number
2. PO Item
3. PO Line

I'm trying to extract differences in month values - eg Values >1 (january)
and <4(april) return 11,12 ,2 & 3.  How can I get results 2 & 3 or february
and march?
Thanks to any one that can help with this.

I have a table of about 12,000 addresses containig a Street No, street name
and a suffix (ave, dr, etc).  Can I break this into separate fields? (there
are also some two-word street names which, of course, have a space between
the two words.)  I need to puul the street # up to ...

I have a query grouped by date with various fields populated by numbers.  I
enter a date range for example: between 1/1/2008 and 1/5/2008, my query is
set to display the totals for each individual day, by both specific field and
also has a grand total column totalling all of my ...

I would like to do following:
I have a query which returns rows out of a table, nothing fancy, just
a normal select statement.
i now would like to add a row at the beginning which would always be

I'm trying to update a Yes/No column based on the CHD_ACCOUNT_NUMBER field
not being equal (<>) to the Prev_Ref_NO field. I think I know what the
problem is. Access is going row by row or record by record and checking if
both columns are equal and then marking "Yes". I need ...

I have a table of sales including location (xy coords) and date of sale.  I
have another table of projects including location (xy coords) of date of
project.  I'd like to sum the number of projects that exited before a sale
within a given distance (euclidean distance must be ...

I have a field with
me@mail.com; smith,patti ; you@mail.com
Im interested in pulling the    smith,patti    only.
I tried numerous criteria in my query but can't seem to get it. Such things