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!

Subtracting two columns

Status
Not open for further replies.
wally2321

wally2321

Technical User
May 30, 2001
64
0
0
US
Please help me!

I am trying to create a query subtracting two columns.

For example, I have field "Before Value" and field "After Value". How can I find the difference between the two fields. I tried the following:

Difference in Value: [Before Value]-[Value After]

I received an error from doing this..
Any help would be appreciated

wally2321
 
Sort by date Sort by votes
Figured it out.. I am an idiot.. Values were not in the correct format.

Sorry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kalyan Ganesan
  • Locked
  • Question
Fails to Inserts two columns but no error given
2
Replies
23
Views
131
Kalyan Ganesan
Kalyan Ganesan
Kalyan Ganesan
  • Locked
  • Question
Query not inserting both the columns into MS Access tables
Replies
16
Views
99
Andrzejek
Andrzejek
rashokku
  • Locked
  • Question
Updating values in a table based on the combination of values in the columns
Replies
2
Views
55
dhookom
dhookom
rashokku
  • Locked
  • Question
Selecting data from MS Access table columns based on column location instead of column names
Replies
5
Views
77
combo
combo
weightinwildcat
  • Locked
  • Question
Count of columns/fields in a query or table.
Replies
1
Views
36
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top