Software

Ask something
Discussion Locked

Microsoft Access

0 helpful
5 replies

by regamy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

user is in Access, has two tables....first table - Masterlist; second table - list with information that he wants to exclude from the first table

has a column in both tables named invoices (actually VP) and they are linked together..wanting to have all the fields shown from one table in a query but wants to exclude the information in one column..

5 replies

by richtee

There is a very simple and explicit solution if your request is only to not show the data in one column in a query:

Open your query in design view. Uncheck the check box in the ?Show? row of the column you do not want data to show. When you runyour query the data in this field will not show in the results.

Hope this is what you are looking for. Rich

by donq

RichTee is correct however it might be a good idea to forst construct your query placing each field from both tables in the recordset. (Don't use astrics)

Once everything shows up as expected when you click the exclamation mark on the toolbar (The "run" button) THEN uncheck the field you want to eliminate and recheck "run". Save (and name) your result.

This discussion is closed to new replies.