When calling excel file from Ms-Access it display security warning. How to
programmatically supress this warning?

I am trying to work out how to have multiple lines in one address
field for Access?

How can I cut text fields in a query like the example below,
-0.132861,51.591273,0
where the first part up to the first comma becomes one field, and the second
part, excluding the last comma and trailing zero becomes two (new) seperate

Okay, I've posted and tried.  I'm not sure if the problem is in my tables.  
Anyways I have two queries that produce results based on different date
ranges.  I want both of those to pull into one query and then I can build a
report.

I have a query/report where I'm grouping by a text field (Clinic Name) and
for the records with no data in the Clinic Name field, I use an IIF function
to insert "No Clinic Name Specified" in the Group Header (also in the details
section).  

I have a Pass Through query that looks like this.
select
Location,City,State,Country,Pings
from

The query below returns sales made in 2007 and 2006 and works fine. However,
if a client didn't have sells in 2006, the query returns empty fields (for
2007 as well).
Can anyone pls tell me why? I think the problem is with the WHERE statement

Not sure if I've started this project the right way, so please jump in and
offer suggestions.  Basically we track monthly totals.  I have columns for
each month dating all the way back to July 06.  
I want a query that will pull in only the past twelve months data from those

My query works great for entering information in two fields in the criteria
row and I get the data that I want.  When I run the query it asks for a base
number and then a supplier code, I click run and it returns the data that I
want.  I have a table with a couple of hundred base ...

Hi, i have read some posts of inner join and outer join, but no one
could help me to solve my problem :(
I have 2 tables
1) tblRecords (having, article; User;date in; date out; service)

In an Access (2002 SP3) query, I've set the properties format to Percent.  
I've written the formula:  Field 1 / Field 2.  When Field 2 is 0, I get the
#ERROR message.
So, I do the Iif statement when Field 2 = 0, "", Field 1 / Field 2.  The

I have a field, OCLC NO, that contains info in various formats and
various lengths. I want to extract only the part that comes after ocm.
These are the 3 types of information contained in this field:
(DLC)97048845

In my database, if a person tests and gets a positive then can test again to
get a negative.  These are recorded as individual tests with one result
positive and one negative.  Is there a way to count or exlude someone in a
query based on both those tests together?  I'm not sure ...

I have a 'Delete' query that used to display a message box saying 'You are
about to delete 95 records.  Do you want to continue' - Yes/No  -- But now
the delete query runs and deletes the records but the message box does not
display.  Is there a simple way to get the warning ...

Hi all...first post in about a year, but you all (on other access ngs)
were so helpful last time I couldn't imagine not asking for help
again!
I am trying to write a query that populates several lists (of certain