Activity Stream

Do the first calc in a textbox then in another textbox reference the first. You can set it as not visible. =IIf(txtSumof6Compounds = 0, "ND",...

Hi moke123 Thank you very much for the 3 examples!!!!! are great!!! with all of the them I have excellent ideas how to solve something like...

Hi June_7 Thank you! I have followed the advice and worked great!!

Was that addressed to my post? Your example is pretty poor, as it seems the next record is linked to the prior record, and vice versa? If the...

Agreed. I did exactly that but don't have a criteria calculation to combine the records. Concatenating the name is the easy part. Doing this manually...

Thanks to June 7th, we see where we were off. Classic case of overthinking the problem. This is the working code to get the sum. =IIf(<>"ND"...

I am thinking you just need simple concatenation if you link all the tables correctly Brand & " " & Size & " " & Type & " " & Resolution & " " &...

Wouldn't Allen Brownes Concat do that, or theDBGuys? http://allenbrowne.com/func-concat.html...

I would have thought, just removing DeviceName would be all you need to do? You already have a T or M Then you would get ...

Don't think I'd do that to the table itself. Perhaps create a query and drag that table into it 2x. Put an equal join between 1st and 6th fields. Use...

Thank guys! So, I followed Welshgasman's advice and removed the grouping by DeviceName and then incoroprated most of ranman256's advice but...

I did look at both pdfs. As I said, Sum is an aggregate function and aggregate functions aggregate records not fields. Remove Sum from the...

I'm getting a little carried away, but here's another version which will change labels as well as command button captions.

You are also grouping by Device Name which will be unique? Remove that and you should get the counts you require.

Q1: select Dept, iIf(Kind="T",1,0) as 'Terminal', iIf(Kind="M",1,0) as 'Mobile' Q2: sum the columns in Q1

Here's another version as a custom class. It was relatively easy to convert to a class. Make sure you set a reference to Microsoft Scripting...

I tried to export the report, but was unable to. I can't send the DB. It is populated and has data on the web. Many tables are used to produce the...

I'd say therein lies your problem if I understand what you're saying. If you read this then post back and clarify it might help....

Here's a different approach. It can be improved a bit but it might give you some ideas. Might be a good candidate for a custom Class. NOTE: I...

Hi Wendy Welcome to the forum. I agree with Welshgasman. Do NOT have lookups at the table level. Use a combo on a form for lookups. See...

As you describe it, you need to make it a multiple value field wich is not a good idea either. Use a junction table.

Do not have lookup field in the table. Period. Just create the lookup in a combo.

Hi Wendy Welcome to the Forum. Are you able to upload a zipped copy of the database with no confidential data?

Another approach: tblTitles: TitleID, TitleName, ...; tblTitleArticles: TitleArticleID, TitleID, ArticleName, ...; tblReferences: ReferenceID,...

Result is whatever field you want to sum. Since only had the PDF as guide, that's what I thought the field name was. However, now I see there are 2...

Result came from your PDF. If that's not the field name, change it to whatever the field name is.