Hello everybody, I have this query based on a table in which I have 2
fields. One of them is a medium date one. In a form I need to input the date
and the query should return every operation (if any) which have taken place
that day... how can I do it?

We have a client ordering numbering system like A nnnn/yy where yy denotes
the last two digits of the year. I want to be able to retrieve this year's
orders. The problem is that some orders are A nnnn/05 eventhough the date on
the order is 2006. So if I retrieve by Year(Now()) I ...

I need your help.   I'm trying to break three words in one columns by
space into three different columns.
example:  Address
-  45 Waterfront Road  (one column)

I have a macro I created to transfer text
Transfer Type Export Word for Windows Merge
qryname
file name

Hello;
I have a tranform query which shows:
Row: Col1       Col2     Col3   Col4     [Concatonation]
Fail:   Rpt1    Rpt60   RptA    Etc.    Fail: Rpt1, Rpt60, RptA,

We have a database which contains records with data for various legal
filings.  One of the fields for each record is an actual embedded Word
document of the legal filing for that record.
We would like to be able to do queries for terms within those Word files.  I

I have a query that collects sales information that includes dates  I am
copying this to an excel spreadsheet for another dept.  I have the date set
to short date the other dept does not want to show the year in their excell
file.  When we try to reformat the cell in excell it will ...

I need help creating a script to automatically link 2 databases from 2
servers. I have successfully connected 2 databases manually under Get
External Data --> Link Tables, and I have run the query to get the right
result.

  I have a table of approximately 1400 rows of text.  I am trying to break
the text into a few fields.  The substring that I am trying to break by
consists of 2 or 3 letters, followed by 4 numbers.  I don't know what the
letters or numbers are, just that it will be 2 or 3 ...

Can someone explain why this query wont run? I get 'Must be updatable query'.
I clicked on Help but nothing made sense.
UPDATE tblActivityQuestions SET QuestionID = (SELECT Q.ID FROM tblQuestions
As Q WHERE tblActivityQuestions.ChecklistID = Q.ChecklistID AND  

IE7 still sux - Firefox 2 RuLeZ
I actually called Microsoft about IE7 and disabling tabs.
They pissed me off and finally admitted there is no way
to remove tabs or keep the menu bar from disappearing.

I'm trying to create a value called Months then call the results Jan, Feb,
Mar... based on the Closed Date. But I don't want to include the year so that
it will work year after year...  This code may help you understand what I'm
trying to accomplish.

Is there a limit to the number of nested queries that can reference a
parameter?
I have a series of 5 queries that I use for various levels of analytic
detail.  The first of these queries has a parameter defined, and works great.

I have a table of 1800 names on a master table that I am trying to match to a
table of 70,000 vendor names.  I want to see a match if the name on the  
master table is John Smith but the name on the cendor table is John C Smith.  
Is there any way to do that in Access?

I am trying to build a calculation in a query where if a field is blank,
return a blank or run the calculation. Below is the IIf statement I am using.
Even though [SumOfTotal FY06 Expenses] is blank the formula is still running
the calculation instead of producing a "blank".