I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97
database. The problem is every time when I use WHERE clause with duplicated
numerical value, it will fail....
For Example:

In access when creating a query I want to format the date of the output to
dddd, d MMMM yyyy (e.g Wednesday, 15 Novemeber 2006).  I found the function
formatdate() but I am unsure on how to use it.  Theory would be to do
FormatDate(String, 'dddd, d MMMM yyyy'). It is something so ...

Hello all, ok I have an issue here.. I have a cross tab query that has
to be used in a report and the columns will increase or decrease
depending on the selection criteria... is this a dynamic report? any
tricks to this?

Hello everybody. I'm new to Access, and I've been trying all day to
write a simple query that will compare a field in two different tables
and show me the differences.  Here's what I got...
I've got two tables with ONE field in each, containing purchase order

How do I query all cells or the whole column of a field in a table into one
cell?  I will then export the newly created table for use in a Word merge.

I'm needing to create a calendar table in my database - fields should be
date, start time, and end time (hour blocks from 8 am to 8 pm).  I want to
have it as a macro, maybe prompting the end user to enter the year and
creating the table (or appending new year's records in ...

I created a form with a combo box to select query parameters.  I run the form
from a report.  Everything works, but prior to showing the data I receive an
error message:  "The expression you entered has a function name tha Microsoft
Access can't find."

I am developing a small stand-alone Access application that uses many
queries and I am constantly making changes to the queries.  I would
like to run the queries in VBA by simply calling them by name.  This
seems easier than constantly changes the Select code in VBA.  The

Errors about Format(), Right(), Left() functions  started when I took reports
and querys made in Access2000 and applied SP3 environment.  Is this a dll or
ocx issue?  How do I get that functionality back.

Hi, we use Access 2003 to hold our e-mail lists. Every month I have to
import new e-mail lists as tables the database, but before I can use those
tables, I must perform delete queries on them against our massive opt-out
table for customers who don't want our e-mails. Is there a ...

I have a combo box that has a rowsource associated with a query/view. I'd
like to add the option for "All" at the top of the combo box. I see this all
the time, so there must be a way to do it.
The results I want are:

Please assist
Need totals on
3 groups
group 1:  certain titles belong to exec group

I have a query that has a business type field.  The field is populated with
either a 1 a 2 or a 3.  In the fields criteria, I've used a criteria that is
linked to a frame on a form.  Here is what I want to do:
I want to be able to filter each of these three business types, but I ...

I have a database that has two drop down lists - one for employees, and
another for a group. I also have a checkbox that is checked whenever
correspondence meets certain criteria. What I would like to do is to have ONE
filter/query that is the same for ALL the groups (all Admins ...

I am trying to generate output from a query for a large list of company names
with associated individuals linked to these companies. Ideally, I would like
to specify a particular company, say Company X, and get a list of all those
individuals linked to that company, for examples, ...