I have used the Instr for providing the end user a choice of multiple
parameters and it works but i have tried to use this option on another field
called vendorAccts so results will be filtered per the multiple accounts &
Multiple VendorCtry entered but it does not work. Is the ...

While trying to do a query to return null using IIF, I found irregularities.  
I know the problem is that the field allows zero length strings and that the
field has both null and ZLS in them.  I wish to know how to remove the ZLS
and set it back to null.

I have a text field that users entry in attribute data.  These attributes
change frequently and to provide a smooth flow I allow users the ability to
create the attributes.  Unfortunately they don't always follow the same
convention.   Luckly it is always at the end of the string ...

How do I return the latest date from a linked SQL Server table in a pass
through query?

Hi all, my goal is to search by entering a Month, Start Date, End Date and
Year to a query. What I have now gives me just the month of this year. My
current SQL is posted below.  Any help is GREATLY appreciated!
teph

I am looking for a site that would provide a tutorial to design a form
that allows the user to select the specific values (pull down menus)
for each query value. These query values, once set, would be used
to develop a report.

I would like to run a query by excluding the fields that have no data.  There
are three fields Email, Email2 and Email3.  Some people have none, one, two
or three email address.  How can I run a query to show only the people who
have email address and exclude the ones who have ...

I have a table with duplicate records in it.  This happens during an External
Data file import from an Excel Worksheet, sometimes the user imports the same
worksheet twice.  The table does NOT have an Autonumber ID as a field.  The
table is indexed with duplicate fields allowed.  ...

Hey guys, I need to create a limit parameter that needs to ask for a dollar
limit each time it is executed.  
For example, if she limits the list to customers that have a total 2007
sales of greater than $200, the list may include over 50 customers.  But if

I'm new to Access Monster, but not access.  Using Access 2003 and would like
to use the 1st April as the start date for any particular reporting year so
that I can pull out historic data from a much larger dataset.  
My very simple query selects a single field record (Date format) ...

I've got a very simple append query to do but the table I want to append to
is not in the drop down list when I select append query and I can't figure
out why.  All my other tables are there and the table design looks fine. I
can add data if I just want to type it in.  I've got an ...

I have a table that contains one field.  I will be breaking this field into
several other fields by replacing the commas with semi-colons and then
exporting the table to a text document.
The problem I'm having is when there are any commas within quotes, as shown

I have two query fields one which divides into the other. i.e. fieldA
divided by fieldB = fieldC, easy enough, except that instead of
getting an answer such as 2752/2800 = .9828 it gives me .90 it rounds
it. I went into format field to standard and I added decimal places

I work for an insurance co and I have duplicate data from a query by claim
number.  I need a way to combine losses by claim number based on that claim
number.  ex:  
claim#    losses

I am trying to group data in a query (Access 2007). The scenario is this: I
have a database that keeps track of monetary gifts. Part of the query is
coming out correct - I group by the donor's ID and a few other fields, then,
I want to pull the most recent date of donation and ...