New to Access

[RoadRunner]

Hi ,



Using Access 2003 pretty much for the first time as the data I have is too big for excel and 2007/2010 is not supported by my company. Bugger , head wall, bang, better figure it out etc.

Anyway moan over. I need to take date that is in two tables one being payroll data for a liability and the other being invoice data for the deduction. I have populated a sample table, linked them and set up a simple query to combine them.

This by some miracle works, but now I want to compare them. I.e. in my querry I want to set up a bespoke field that takes the invoice value away from the payroll value.

Please would someone advise how I do this.

Thanks

Beepbeep

[Bob Fitz]

Hi
Create a new field in your query with:

Balance:[Field1]-[Field2]
You will need to change the field names to the names of your fields.

This should give you the result you require in a column called Balance.

[RoadRunner]

Hi Bob,

Thanks for that, though I could not get it to work.

I have attached a mspaint image of what I put in.

When I run the query it comes up with an input box and then I get a blank query grid.

Obviuosly doing something wrong.

Beepbeep

[RoadRunner]

Hi,

It's ok figured out my mistake,

I put in a typo and the reason it returned no values.

Opps, complete novice at this, started yesterday.

Beepbeep

[Bob Fitz]

Hi

My eyes are not as good as they once were so I can't be sure, but I think you've put

Balance:[Field1]-[Field2]

in the wrong place.

It should be in the top line of the querry grid (where you have Expr) that is labled on the left with "Field". All other lines in that column should be blank.

You are getting the input box because you have something in the Criteria line that is not required and not understood by Access.

[RoadRunner]

Yes, that makes sense.

Thanks

Matt