I need to be able to search for specific sub-strings in any position in a
string.  For example, in a table of product descriptions, I may need to
search "OREO" where many of the products will have product description fields
that say "NABISCO OREO COOKIES" or "OREO COOKIES" etc.  ...

How do I keep the position of tables in the Diagram Pane of Query Designer
when I save the query? As soon as I save the query the position of all the
tables in the Diagram Pane revert to some default position of Microsft's,
which means that each time I open the query in design ...

I have a trending report that is trying to show an employee's time taken by
day of the week. I have a query that uses an expression to convert a date to
a day value.
On the report I would like to have headings that show each day and then set

tblPatient contains the following fields:
DiagnosisID (foreign key from tblDiagnosis)
DiseaseStatusID (foreign key from tblDiseaseStatus)
ScreenStatusID (foreign key from tblScreenStatus)

Hi. I have a querry that work very well over a Number null field but not over
a null text field. So my idea is to convert all zeros to Nulls. but the
result is text to access so my other querie don't work.
I use this to convert the zeros in Nulls:

 i created two accounts on my windows/xp installed computer system. i
accidently deleted one account and its files are copied on the other
account on its desktop. but they are not accessible.
            how can i access those files.  there are some mpeg, doc

I am writing a visual basic procedure as follows:
Public Sub DaysAvg()
'Calculate the average value of a given value.
Dim dbs As Database

I have a table that shows material numbers, vendor numbers, e-mails ect.
Some of the material numbers are shown twice in the the table. This is
because a vendor can have 2 e-mail adr. For different reasons I need a query
to always return the first record it finds for each unique ...

I have a table containing several Projects and its Phases.
I made a query that Counts the total of projects in each phase:
Query_Projects_Phases
Phase    CountOfPhase

I am working on data that was appended into my table from an Excel file.  The
field name is [Approval Date], it has a Date/Time data type with a short date
format.  I believe the data was generated from a NOW function in Excel.  The
Access table displays the approval date as ...

Long post - sorry, but I'm trying to give you guys the info you need.
I'm trying to write a query that will give me all the information I need
 to fill fields in a Word merge document.
TBLCLIENTS        TBLCLIENTCONTACTS        TBLCONTRACTINFO

I have a subform [MYOB_Cards query subform] in that I have a [text30]
in [Text30] Ihave
=NZ(Sum([Price]*[quantity]))
On My MAIN Form I have a Text Box [185] in it I have

I have two tables - tblPeople and tblBooking. Referential Integrity is set
from tblPeople to tblBooking on the Client_ID field, which is an AutoNumber
data type. I created a query with these tables. When try to add new data, I
am only able to enter data in the fields of the ...

Hello, I have a button on my form (Maindb) thats named ReportsSwitchboard and
when clicked it brings up a form that is a paramater form. Is there some way
to hide the MaindB form when the ReportsSwitchboard is open and when the
ReportsSwitchboard is closed the MaindB form isnt ...

I have run a query that totals all charges for a particular orderid and the
results are in a field called [sum] within that query.
I want to update a field called [OrderTotal] in a table called History with
the result of the field [sum] based on OrderID.