Solved Fixing #ERROR when no data is within the field when using this (1 Viewer)

N

Number11

Member
Local time
Today, 00:44
Joined
Jan 29, 2020
Messages
607
Exp1: Val([ORDER_No])

How can i get the wuery to not show #ERROR when using the above for a blank entry please?
 
You must log in or register to reply here.

Similar threads

T
Solved Calculations don't work if one of the fields used in calculation is a null
Replies
3
Views
256
Pat Hartman
P
A
Solved How can I run this update query without messing everything up?
Replies
7
Views
125
aian
A
K
Form blank when no records found
Replies
9
Views
489
kevinh2320
K
N
Insert Data from an Access table to a similar table in MS SQL Server
2
Replies
36
Views
633
cheekybuddha
cheekybuddha
MattBaldry
Query Error in List Box
Replies
2
Views
100
MattBaldry
MattBaldry

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom