I have a database with some data entries. Now I would like to keep the whole
structure (tables, forms, etc.) but get rid of all the old data. Is there a
way to "reset" a db?
Thanks, Thore

I have a huge database, many many tables. what i need to do seems to be a
reletively small job, but i am pulling out my hair over this. I have a table
containing stock details, and another table containing supplier details. In
my stock table, i have a column (named supplier ...

I need to do a report that will ask for the amound of years, for example 3
years and it will give me everyone in the db that had not had an award in the
last three years, type 5 and give all without an award for the last 5 years.  
I know i will need a querry but I do not the ...

What is a quantifier?

If you have database that related to my need as above
please send to my address. Thanks in advance.
Chanthy

I want to do A-B=C but I want the value of C to read as 0 as long as there is
no value in the B coulmn.
HELP ME !!!!!!!

Hello Again.  I'm trying to print a report in landscape.  I've set the page
property to landscape and when I view it in print preview everything looks
ok.  When I print it, the printout is in Portrait mode
any idea's?

I am brand new to Access.  I just took over a job that the previous person
was using Panorama converted to be able to use on Windows.  (It's a Mac
program, I don't know how they got it on windows.)  Since I don't know how to
use Panorama, I decided I would rather learn Access and ...

how di i set up a research questionaire for customers in the food retail

Hello, I installed some fonts today and when I opened Access I did not see
those fonts in the font list of the program. Then I went to the font folder
of Windows and saw that I have many fonts and a number of them is not listed
in Access (and other programs of Office also). What ...

I'm sure there's a simple answer to this but despite searching this site I
can't seem to find what I need, and although I think I might have some
ideas to follow up, I decided it was time to ask the experts.
I've seen many postings where the first response requests more details so

Hi. I wanted to know if anybody knows what can i put in
criteria to do a parameter query that searches a field
when you input a phrase. For example: I used this:
Like "*" & [Enter your username] & "*" and it works fine

Sorry folks, I wanted to post this in
the 'microsoft.public.access' forum, but I keep getting
a "Newsgroup not available" message.
------------------------------------

i am designing my form for my survey and i want to be able to let people know
when they missed a question to go back and fill it out.  how would i go about
that?

I created a form to analyse sales performance.The form is
designed in such a way that it lists all the products in a
combo and a second combo lists all the financial quaters
in which the product was sold. Then other details are