I have a field that contains data as shown below:
Record 1
CN=McGhee\\, David M.,OU=C4A_OA-Dallas,OU=Users and Groups,OU=OIG,OU=LAN
Configs,DC=kc,DC=ad,DC=dhs,DC=gov

I have a table of orders called ‘tblDuesod’.  I want to calculate the total
cost (EuroSodCost) of the orders which have a delivery date (DelivDate)
between 2 specific dates,  then plug plug the result in the control of a
report.  I want to do this for each half-month period thru ...

How can I query by quarterly, semi annual and annually... for example by year
of 2006..i'll  do  have a table coming from way back 1998.. can you pls help
me...

I am using access 2007.  I don't know if that makes a difference or
not. If I want to output an access query to a  text file, it is
putting like a "printed grid" of the information in it.  
For instance:

I have a 2002 Access database with a query that uses a function defined in
VBA. This query works fine when it's run from within the database, but if I
try to run the querydef from an outside program (in this case a VB automation
object) I get an error saying the function is ...

I have a query that returns service_type, amount, and cost_center. I want to
be able to have the user type the filtering criteria in a text box in a form.
Suppose the user wants to search for service_types that are like PC Support.
I want him to be able to type PC Support in the ...

Importing data from Paradox file.  Need to remove records with a Facility
identification equal to 3 characters.  Data in this field can be 3 characters
or 5 characters.  Nothing else.  After removing all records with 3 character
length in Facility identification, I should have ...

I'm trying to execute an aggregate function as part of a select
statement.  It requires me to include all columns not in aggregate
function in the 'Group By' clause.  That makes sense.
However, one of the columns may have null values because it's based on

Have the following query which is not updateable when I open it:
SELECT PlaysByBar_Int_5_Full.Ticker, PlaysByBar_Int_5_Full.[BTO DT],
PlaysByBar_Int_5_Full.[STC DT], PlaysByBar_Int_5_Full.PutPrft,
PlaysByBar_Int_5_Full.CallPrft, PlaysByBar_Int_5_Full.PRisk,

How do I do a full outer join on two tables? Or do I have to do a left outer
join unioned to an exception join...
Jim Thomlinson

I have got a query that I thought was doing what I wanted, but now I'm not
sure.
I am using the following:
<DMax("UnitPrice","tblItems","ITEMNAMEDESCRIPTION = """ &

Access 2003.
My make-table query is used to debug a process.
It involves using a Totals query to create a table, then remove a field from
the query grid, changing the name of the output table, and running the query

I am using several text functions to create a field which forms the text of a
hyperlink. This is for an append query.
When the records are appended to the table, the field shows as a hyperlink
but clicking on the hyperlink goes nowhere - it doesn't even launch browser.

I am new to Access 2007.  Every time I create a query and get it fine tuned,
and then save it and give it a name, then close out of it and then select it
to run again, everything that was in the query is gone and I am back to the
beginning where I have to add tables/colums, ...

I've inherited a database and while trying to familiarize myself with how it
was constructed I came across queries that have an "filz" prefix.  I see that
the "fil" part is for a file list box but what is the "z" part?  Also, these
are queries that pull items from a help table ...