Previewing data

R

Richard

Whilst writing a query, is it possible to preview the data
as you select fields out of tables and add criteria? This
is available in Microsoft Query, and I find it very useful
as I'm not always sure what is in the fields!

Thanks a lot.
 
P

PC Datasheet

Just cick on the button with the red exclamation point in the toolbar at the top
to run the query.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
R

Richard

Thanks. I'd got that one, but this is not a 'live' query -
ie you have to do it each time you change something. The
preview screen in MSQuery changes as you add/remove fields
or criteria.

Any other ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Access Dcount (multiple criteria) 3
Can't create a report from my query in Access 1
conecting to Access Database with excel 6
Creating a "Greater Than Date" criterion 2
Calculations, Queries and making it all come together in my table 4
Query Question 3
Searching for Records in a Report 1

Top