Have query pull filler if citeria not found

DBnub11

Registered User.
Local time
Today, 08:13
Joined
Jan 5, 2011
Messages
26
Is this possible I wanna have it so my crosstab is always full even if it has dummy data in it
 
Having dummy data stored in your table would violate your data integrity. If there is no applicable data, don't run the query. You can use some code to check to see if there is data & if not return a message saying that "No Data Meets Your Criteria" or something like that.
 

Users who are viewing this thread

Back
Top Bottom