connecting 4 queries in 1 form

[pantanna]

I had i great help a few weeks ago for making a query
now i need help for a form
.
i have a table table one
date num
1/1/11 100
2/1/11 200
3/1/11 300

i find the difference between current date and last date (100) and calculate it with the according rate. (1,80). this should make 180
i have 3 more tables with rates and numbers and always calculate the same way.
what i need is to conjuct them somehow so as to open only one form and enter the data.
ie date number for table one, two, three, four and hava a subform with the calculated results. i could not connect the four subforms, because they had the same root.

i really do not know how.the way.
i tried to upload samples but it was to big.
thanks for the help in advance.

 

[vbaInet]

From the sounds of it it cannot be done. But we need more information. These other tables, do they have the same or similar fields? If they do, why is that so?

 

[Rabbie]

i tried to upload samples but it was to big.
thanks for the help in advance.

To reduce the size of your db for posting here just delete most of the records just leaving some sample records in each table. Then run compact and repair. If it is still too big use ZIP (or similar) to compress it further. Remeber to tell us which version of Access you are using. Some of us do not have the latest versions so it is helpful to know the version before we download

 

[pantanna]

From the sounds of it it cannot be done. But we need more information. These other tables, do they have the same or similar fields? If they do, why is that so?

the db will be used in a gas station. i would like to calculate the numbers of the pump counter of each kind of gas which is selled. unleaded, super unleaded, diesel, super. ie
date counter nr
1/1/11 1578
2/1/11 1580
3/1/11 1585


the difference of the two days ie 1580-1578 calculated with the rate of the according gas type will make the amount of euro we earned.
2*1.80=3.60Euro

so i would like to make it in one form to make it more easy i could make the queries but it was impossible to join them into one query the results where mistaken.

maybe the idea or the way i started all the db was wrong, this is way i need support.

i will try to reduce the size of the db and send a copy.
in the meanwhile i would appreciate any idea.

thanks so much