Your videos have been super helpful! Since starting as a Sales Support Admin last April, I've built two databases for our Sales team. The results have been highly praised and the time to develop the DBs was reduced because of your videos. Thank you!
Greetings! I really enjoy watching and re-learning from your tutorials. I've been away from computer languages/applications for some time now. My 5th or 6th career change has me back into the game and remembering a lot of what I've forgotten. I'm thinking about becoming a member to enhance my SME status as a CSA contractor. As I build a rather large DB I'll add your resources along with others. I look forward to seeing more of your tutorials. Cheers!
I was able to have a query do a calculation as you describe- thank you! However, how can you update a table field with that calculated query? For example, if a record shows a customers name, a qty of a particular item purchased, to show the total in a table field? If i try to add a lookup field from that query, i get an error.
I only recommend creating forms based on queries when you are solely editing records from one of the tables in the query. If you have calculated fields, for example, quantity times unit price, and that's a non-editable field, then you're fine. However, you don't want to have fields that you can edit from multiple tables because that just asks for trouble. I actually have a video on this topic coming out pretty soon, so good question.
Just specify the table name in front of the field name. CustomerT.FirstName, for example. I actually have a video on this coming out soon for beginners.
Bit of an unrelated question but I created a calculated query. When finished, I unchecked the "show" box for the fields I did not want to see when it runs. Is there a way to bring them back and show again? I wanted to see them in design view again. Thanks!
Hello. How to calculate the difference between 2 rows in access? The difference between 2 cells of the same colunm. for exemple the difference of salary between 2 workers?
hi, i created a query, but i have no idea how to bind this table+query with c# datagridview. i have no experience in it but i do have to create this project. can you help me with that? what should i do to bind the table with total column in it with datagridview???
I wonder the correct way to change unit price while maintaining all the historical unit prices on official reports for IRS and/or display forms showing customer journals or ledger entries.. what's the standard solution calculation with dates or a make table..? Cheers ..
Hello, I was trying to calculate total(or rather sum) of fields, some being empty (null). The problem is that the total can't be calculated without having a value in one of such field. zero value gives a total but i dont want to use zero in my fields, i just want it to be empty. is it possible to have some empty fields and still get your total? To be more precise: total: [field1]+[field2]+[field3]+[field4] ... and field3 is empty
Sir I have database for employees, I want to get thier annual leave depending on their service period, like each employee has 40 days leave , and I want to get their service years by subtracting their appointment date from current date. While formating the field as number , but unfortunately I am not getting the correct period years and months. Please let me know how I can I do it.
how can I make a summing process for aspecific values such as a some value from table products and their prices from pricee table. or any process as this
Hi, Thank you for all of your reply. Let me explain my situation. I have a receipt to charge customer & received payment (No more invoice). I have 4 items to be charged, and each receipt charge one item only. 2 items have a fixed rate (will be revised within a period) & 2 items without fixed rate. So when I select the fixed rate items, the calculation of [itemVaule} * [PayPeriod] can be workable. But in the items without fixed rate, I hope I can put the [Total amount] by myself. In addition, I need all the above to generate a report. Hope the above will give all of you a right director to think of my problem. Thank you again for your help. I had tried to calculate in query by using an expression : [ItemValue] * [PayPeriod], but the result is can't edit the [TotalAmount} field in FORM. When I had tried to use an unbounded test box in FORM and make an equation in ON CURRENT EVENT - Me.TotalAmount = Me.ItemValue * Me.PayPeriod, it can edit the [TotalAmount] field, but it can't save it, I need the [TotalAmount] to generate report.
I get a ton of questions every day, and I don't have time to answer them all here on RU-vid. Feel free to submit your question on my website at: 599cd.com/AskYT
Greeting ..nice tutorial ...i have question how to get AVERAGE 3 item in one table.. example: table Student, field: - Math - English - Science Usually I finish this problem with -> total: ([Math]+[English]+[Science])/3 but i want use-> AVERAGE(([Math]+[English]+[Science])) that still problem and not yet solved, maybe you can help me... thanks
Average doesn't work that way. You need to add up the 3 fields and divide. Average can only be used in the form footer on a single field (Avg or DAvg).
I have a table as follow: Empl Dates Hour Sum of Hours Emp1 date1 8 Emp1 date2 5 Emp1 date3 4 Emp2 date1 1 Emp2 date2 3 Emp2 date3 5 .... How do I sum hours for employees and place the sum value on each rows of in MS Access Query and by not using SQL or VBA? like Empl Dates Hour Sum of Hours Empl1 date1 8 17 Empl1 date2 5 17 Empl1 date3 4 17 Empl2 date1 1 9 Empl2 date2 3 9 Empl2 date3 5 9 and so on.