where do I write a query

T

Tiff

Please Help!

I have a table with 300 000 objects (rows) with 2 columns. I want to perfom
(columnB/columnA)*100 but I have no idea where to put this query/equation or
how to make it work for 1 cell and then fill down the column. The help menu
says that I can do a query but doesnt tell me where or how to do it... I am a
beginner. Any help would be appreciated.

Thanks in advance.
 
R

RobFMS

Tiff

I would first recommend getting a very basic, easy to understand book on
Access. Focus on the areas that describe the database window, the "Tables"
tab and the "Queries" tab. The book will show you how to create a simple
query and what each of the different areas of the Query window are called.

I say this with great care and gentleness. As myself, or someone else, tries
to describe the steps you should follow, it will make it easy to understand
if you have some background knowledge of how to open a table, open a query,
and create & execute a query.

The query you would most likely run, will look something like this:

Select Field1, Field2, (Field2/Field1) as Field3
From Table1

By all means, if you still have questions. Post them here. I've bookmarked
the posting.


--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top