Hi there.  A bit stuck and need some help.
I have a table called Print Actuals.  THis table tracks the print count for
a series of printers.  It records the date and the number of print
impressions.  

how can i serach for records that contan 2 words, for example. search for
records that contains : 'access' and 'query' .
what's the best way for that
thanks in advance.

I bought a dvd burner and have nero program.  A newspaper ad for new gadgets
- Advantage usb  made by turtle beach video. It cost $130.00.  The
information on the web page makes it sound easy to use.  Has anyone used this
device?  It works with windows xp.  

I am doing a stats database and I would like to query data for the following.  
FTM/FTA and get the percentage, I did this one OK but I get a error in the
field when the percentage is zero.  1/2 = 50% work but when 0/1 or 0/0 give
me a zero.

I'm trying to append values into a daughter table, when parent table records
do not exist.  I get an error message that records were not added due to a
key violation.
[Parent].[ID] is an AutoNumber primary key field and is the only required

Appologies if this is not in the proper discussion group, I am using Access
2003.  It would be very beneficial for Access to have all of the
mathematical, statistical, financial, etc. functions that Excel has.  For
example, I would love to be able to group a dataset by month and ...

I have a table like
week id    week     sig    sf     drop     rand
1                1          4     2       1          1
2                2        new#plus anterior number

I have two tables that I am trying to cross reference.
Table 1 contains a single column list of telephone numbers
Table 2 contains two columns. Column 1 contains people's names and column 2
contains their telephone number.

I combined both of these procedures in one subroutine that calls a report.
How can I make this sub run the report without displaying the warning
messages that need approval to continue?
Thanks,

I have a form w/ a subform.  The subform has a query for data that uses the
Date() function to only return todays records.  On the main form is a
checkbox  which when checked, returns the records for todays date. Unchecked;
returns all recrods.  But iti doesn't work.  I used an ...

I've seen it done, but have forgotten how to write it out... I have  an
action query (Make Table qry), based on a single table, I have a field named
ExpenseElement. It is a number field, integer. I have set the criteria to
look for 3 expense elements: 111 or 120 or 900. I want to ...

I use a query in a subform.  I then put a checkbox on the main form that when
checked is supposed to return data for todays date.  If not checked, return
all.  I have an IIF(checkbox, Date(), <=date()) stmnt in the criteria field
of the query date field.  But no matter if the ...

Is there a way in Access to be able to prompt for the table name that you
would like to run a query against?  What I'm trying to do is to create one
query to access different tables with the same fields but different values.  
Can Access accomplish this?

I have a master trial balance table with the following fields:
  Period
  CoNo
  AcctNo

I have an existing report query that serves its purpose well.  I would like
to pull in unrelated data (sunrise/sunset times) into the report.  I find
that if I simply add the unrelated table to the report query; it works well.  
However; I feel I must be violating some database ...