Darshan Hiranandani : Fetching Attachments Between Tables and Calculating Values in Forms - Seeking Suggestions (2 Viewers)

[darshanhiranandani24]

Hi Everyone,

I’am Darshan Hiranandani, I've got a couple of questions and thought it might be more efficient to post them together in one thread instead of multiple, but please feel free to jump in with any thoughts or suggestions!

Question 1:​

I have a table with 10 fields. If I create a query and simply drag the asterisk (*) from the table into the query design, will that count as 1 field for the query or does it count as 10 fields because it’s pulling in all 10 columns from the table? I'm trying to understand how this affects query performance and structure.

Question 2:​

I’m working on a form where I have an unbound control and 3 input fields in the detail section. The goal is for the unbound field to display the sum of the values entered into those 3 input fields.

Currently, I have the following expression in the unbound field to calculate the total:

Regards
Darshan Hiranandani

 

[June7]

Q1: 10 fields
Q2: no expression provided but what happens?

 

[GaP42]

Hmm -- is this the same question?
https://www.access-programmers.co.u...rding-query-limits-and-form-additions.333012/

 

[June7]

Certainly looks the same.

If you want to simply add 3 fields of one record, that does not use Sum(). Just: =Field1 + Field2 + Field3

Sum() is an aggregate function and would be used in a query or textbox of form footer or report footer to sum all records.

 

[Gasman]

Have you thought to try it and see what you get?

 

[GPGeorge]

Hi Everyone,

I’am Darshan Hiranandani, I've got a couple of questions and thought it might be more efficient to post them together in one thread instead of multiple, but please feel free to jump in with any thoughts or suggestions!

Question 1:​

I have a table with 10 fields. If I create a query and simply drag the asterisk (*) from the table into the query design, will that count as 1 field for the query or does it count as 10 fields because it’s pulling in all 10 columns from the table? I'm trying to understand how this affects query performance and structure.

Question 2:​

I’m working on a form where I have an unbound control and 3 input fields in the detail section. The goal is for the unbound field to display the sum of the values entered into those 3 input fields.

Currently, I have the following expression in the unbound field to calculate the total:

Regards
Darshan Hiranandani

Q2: This sounds very much like a table design problem. When you need to sum fields in a record to get a usable value, that's most likely a Repeating Group.

Please show us the table in question. Show us the table with some sample data in it.

 

[Pat Hartman]

You seem to have posted both of these questions under another account. @The_Doc_Man or one of the other moderators who checks accounts should look into this. None of us gets paid to help you and using multiple accounts where you can't even keep track of your questions wastes a lot of our time. I personally answered both of these questions for you already.

 

[The_Doc_Man]

@Pat Hartman -
darshanhiranandani24 had at least two other accounts but now has only the -24 account. The trimming occurred a couple of months ago.

 

[Pat Hartman]

But we have still answered BOTH of these questions at his other accounts. That data is still available. He could have linked to those. He could have put comments as responder in the originals and pointed them to the new thread. He is a time waster. I don't know what his game is.