Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NO DATA RETURNED IN A SELECT QUERY

Status
Not open for further replies.
NewComer

NewComer

Technical User
Apr 26, 2001
35
0
0
US
I have developed a report based off a select query, the user must enter an aircraft number at the prompt, my problem is I need the query to return a "no discrepancies" statement in the discrepancy field is no records are returned. Can this be done, if so was wondering how to do it. Thanks in advance for your help.
 
Sort by date Sort by votes
Right now in the "no data" property there is a message box that says there are no records for this aircraft, however, I want to replace that with a blub the says "no defects" in the discrepancy field.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
184
lameid
lameid
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
174
combo
combo
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
151
monkeysee
monkeysee
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
181
TheresAlwaysAWay
TheresAlwaysAWay
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
174
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top