New user to access need help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I want to know how to run a report from a very basic table. My table is ie:
A B C D E across the top and 1 2 3 4 5 down the side and then in all the
small fields certain ones contain a 'Y'. I want to be able to say in my
report I want the A's and the B's and the D's but only the only the ones
that have Y in the D colum?

I am very new to this access and hope I have explained it ok. I am very
stuck on this and not sure do I write formula or how to.

I have even bought the Dummies guide and am still lost!!!

Thank You
 
Tracey

Your "table" sounds like a spreadsheet, not an Access table.

Create a query (use it instead of the table directly in your report) in
design mode.

Add fields "A", "B", and "D".

In the row of the query grid that holds Criteria, under the field "D", put
"Y" (I assume you have field D defined as a text field).

Run the query. When it returns what you're looking for, save it.

Create a new report, using the New Report wizard. Base it on the query you
just created.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top