Web Development

Ask something
Question Locked

Access database basics

0 helpful
4 replies

by sean

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am new to databases--I have an Access database that that matches vehicle numbers from a workorder to obtain the type and billing amounts. The query works fine, except I don't know how to make a separate report for those vehicle numbers on the workorder that do not match the units in my db. I know these return null values. What is the process or sql statement that finds all the nulls or non-matched items from the workorder.

4 replies

by dr dij

for a query
put Is Null
as the condition

under the field you want
(drag this column from fields available to a column)
if you don't want the field to show in query, just to select isnull
then uncheck 'display' box under the field

if you're curious about how the sql looks
click on 'show sql'

you can do pretty much the same thing in crystal reports and even switch syntax to VB
in the crystal formula editor

by absolutely

It's quite intuitive. Just select 'queries' and start experimenting. I guess within 30 minutes you'll get exactly the results you need, and have a fill-in-the-blank solution for your next work order.

by sean

After digging in the tools I saw the "unmatched" query wizard. I was trying to do something similar, but had some issues. The wizard gave me exactly what I required. Thanks Much

This discussion is closed to new replies.