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 strongm 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
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

ameedoo3000
  • Question
switch between two open database
Replies
12
Views
533
Andrzejek
Andrzejek
Kalyan Ganesan
  • Locked
  • Question
Fails to Inserts two columns but no error given
2
Replies
23
Views
198
Kalyan Ganesan
Kalyan Ganesan
Kalyan Ganesan
  • Locked
  • Question
Query not inserting both the columns into MS Access tables
Replies
16
Views
191
Andrzejek
Andrzejek
rashokku
  • Locked
  • Question
Updating values in a table based on the combination of values in the columns
Replies
2
Views
79
dhookom
dhookom
rashokku
  • Locked
  • Question
Selecting data from MS Access table columns based on column location instead of column names
Replies
5
Views
144
combo
combo

Part and Inventory Search

Sponsor

Back
Top