calucations

[cdsmumbaii]

Hi, Iam quite newto access.I require help to solve the following
BasicallyI want to find out/rather display difference of two numbers is given numbers. for example I want to display all numbers from 1 to 10 which gives me difference is 4. My result would be :

a1 a2 diffence ( a1-a2)
1 5 4
2 6 4
3 7 4
4 8 4
5 9 4
6 10 4

How I do I write program for this


thanks in advance


cliffs

 

[MStef]

Look at DemoDifferenceA1A2A2000.mdb" (attachment, zip).
If you want +4 as result, it must be a2-a1.
Look at table, query, run query and see.