Search results

Thanks so far, I am learning bit by bit. So the control in my form is the query which is made from my tblsavings. So I have called the query = qrysavings as the main control within the form. I then select each field from the field list onto the form. Important to note though that the form...

Many thanks for that. The issue I have now is when I type values in the form they do not update the table. Obviously it will not store the calculations which I dont want. I have explored the normal issues for example a union etc

Hi, Here is the SQL of the query: SELECT tblsavings.savingid, tblsavings.queryid, tblsavings.I_saving, tblsavings.ac_saving, tblsavings.std_cost_av_base, Nz([std_cost_av_base])/Nz([no_days])*365 AS std_cost_av_fig, tblsavings.saving_type, Nz([I_saving])+Nz([ac_saving])+Nz([std_cost_av_fig])...

Dont quite understand why you pasted that. Im just asking for assistance to point me in the right direction.

I wanted my database to have the ability to add fields together within my table. I read it wasnt possible in my version and it was best to use a query based on the table. The name of my is: tblsavings With the query in design view I have it setup like below. But everytime I save it...

Hi there, After various suggestions I have followed lots of tutorials on how to make databases and making relationships between them. So now I have 2 tables called the following and there fields are underneath the table names: tblsites siteid (number, Primary key) add1 (text) add2 (text)...

Hi, Thanks for the reply. I have spent some time looking tutorials and still cant figure out what I have done. If you were able to post some quick tips based on my example that would be helpful. Thanks

Its been a while since I was creating access databases and I assure you I am very frustrated because I was able to create real complex solutions. I seem to have forgotten the most fundamental aspects of creating a database for some reason and hope someone can help me. My tables: tablename...