I have done a calculation in a number of querys and wish to show the totals in the parent form of the database. I can display the information by use of a sql statement without any problem, but as soon as I link in the querry it then does not allow me to enter new records, anyone got any ideas.
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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sql statement on form not allowing new record 2
- Thread starter logopolis
- Start date
-
1
- #2
logopolis
You may consider using a field that uses
DSUM("[YourSumField]", "YourTable", "[WhereField] = " & FormOrFieldValue)
When the form brings up a record, the sum is calcualted fr the specific record if you set things up correctly.
For the Control Source, have...
=DSUM(....
Note: You can also use a Function call and pass a value to the function. The function returns the number. This apporach works for mre complex queries.
Richard
You may consider using a field that uses
DSUM("[YourSumField]", "YourTable", "[WhereField] = " & FormOrFieldValue)
When the form brings up a record, the sum is calcualted fr the specific record if you set things up correctly.
For the Control Source, have...
=DSUM(....
Note: You can also use a Function call and pass a value to the function. The function returns the number. This apporach works for mre complex queries.
Richard
-
1
- #3
formerTexan
Programmer
Any queries that provide Summation type information are not going to be updateable. In addition to the prior suggestions you can also display Total results seperately in a subform or listbox.
Cheers,
Bill
Cheers,
Bill
- Status
Similar threads
- Locked
- Question
