I have a query and form that joins a one-to-many from two tables.  In one
table I have a field "Item Type" and the options are "Emergency" or
"Permanent" as well as a "Item Amount" field.  In the second table I have
three fields "Emergency Total",  "Permanent Total" and "Total".  ...

The Sex field contains "M" and "F" and "X". The IIf statement will not show
any records when true. I would expect everything except "X". Does the IIF
statment not handle functions as one of the outcomes? Below is the sql from
the query:

I have a string of numbers with a dash and 4 letters.  I need to get rid of
the dash and letters in an expression.   (12345-PPPP) I want the end result
to be 12345
I am using Access 2000

I have a query with 63 fields.  When I try to add a field to the query, it
changes all the "Totals" from "Group by" to "Expression" then it prevents me
from entering any information to the fields form the form or from the query
spread sheet.  (The form information is pulled from ...

Hello I am in a query in Acces and the Field name is called GoldmanCash
There is a table called TOTAL BROKER CASH NOT0 GOLD of where Goldman Cash's
information appears. I am having some problems with reports and the below
keeps happening.

I am having trouble with a query that keeps returning the error message "This
expression is typed incorreclt, or it is too complex to be evaluated."  Any
help you can offer is more than appreciated as I am at a loss...
My setup is one query, one form, and one report.  Ideally, the ...

Hi: Can any one please tell me why this condition dont work:
DHGErrorOutlet.Outlets=[tbl_Events].[PPVVOD_Outlet]
There is one outlet in DHGErrorOutlet and two in PPVVOD_Outlet on same
ticketNum but it print two instead of print one

I am using ACCESS 2002, and am trying to insert a large amount of data from
Access into an Oracle table which has composite PK, several indices, and a
couple of constraints (Non-NULL fields).  I have been advised that I should
drop the indices before the insertion, insert the ...

I have a access query made up of 2 tables [tbl_circuits] & [tbl_sitenames].
from the table circuits i am using fields [cr_name] & [cr_area] from
sitenames i am using [sn_number]
i need an SQL solution which will enable my query to create 2 indexed

I want to list down all ActiveX controls which are registered on my
system.
How can it possible through C# ?
Please help me and reply ASAP.

Below is what my SQL looks like for a query I'm working on.  When I open the
query a parameter box pops up asking the user to input a District Number
which is the way I want it.  But after that parameter is entered another
parameter value box pops up asking for Invoice Bucket.  I ...

How do I check for the existence of a named query before deleting it? eg using:
db.QueryDefs.Delete "qryPromotionText"
My procedure needs to delete the query before re-generating it with new SQL,
but if it isn't there I get an error.  I did have an error trap but the same

I have an application that tables are standardized but can be created form
menus by the users.  I need to be able to regenerate a union query that reads
all the standardized tables (i.e., tblDimen_XXX, tblDimenYYY).  I have the
code that creates the SQL variable in VBA, but I get ...

Hello all I have a lil problem that is racking my brains,
Let's say I have multiple zones, within each zone can be a varying number of
packages.  But these packages can arrive at different dates.  Something like
the diagram below: (let's hope it shows up properly)

I need to create a query where TABLE A would have a  LOCATION field where
there is more than one record that contains the same date in the LOCATION
field.  TABLE B would be just a list of unique locations.
I want a Query that ASKs ( based on TABLE B) for a location and the query