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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subtraction

Status
Not open for further replies.
wroot

wroot

MIS
Jan 9, 2002
9
0
0
US
I am trying to get the difference between to fields in the database through a SQL command and i cannot seem to get it to work
Any ideas
thanks
Dave
 
Sort by date Sort by votes
In the Query Grid, you should be able to define an expression to represent the difference

Diff:=[Field1]-[Field2]

 
Upvote 0 Downvote
Thank You
i was doing it right but i needed the brackets around the field names.
Dave
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jammerdk
  • Locked
  • Question
Calculation - Subtraction 1
Replies
7
Views
13
jammerdk
jammerdk
md092686
  • Locked
  • Question
Date Subtraction 2
Replies
2
Views
15
SkipVought
S
drimades
  • Locked
  • Question
Subtraction field
Replies
5
Views
14
r937
r937
Zonie32
  • Locked
  • Question
simple subtraction not working
Replies
2
Views
13
earthandfire
earthandfire
kmclane
  • Locked
  • Question
Access can't do subtraction?
Replies
6
Views
17
kmclane
kmclane

Part and Inventory Search

Sponsor

Back
Top