Search results

Could you upload the DB ? I'm struggling to see why this can't be done in the one query, but it is early....

Hmmm.... maybe you could use a recordset and some VBA automation to get what you want. Cycle through the records and send the data to word using automation, I mean.....

What line does it error on?

Welcome to the forum MariaC!

Not 100% sure what you're getting at here, but my first thought was about creating different "keys" for different levels of data - as in "BM" as one, "BM2K" as the next level, "BM2KA" as the third and so on. That way you could run totals for each level of detail, just running queries and...

What's the bound field you're using from this combo box? If it's a field that contains dupes, that might be your problem....

What does your ISP say about it? PS you don't need to ask for a reply - if people can/want to reply, they will :)

You'd have to have tbla and tblb in separate recordsets. On an event, say a button click, you'd have to navigate to the correct record in both recordsets, then just do something liketblb_recordset.edit tblb_recordset!keyvalue = tbla_recordset!keyvalue tblb.recordset.update

What happens When you try and view the result of this form? And what is totalaccrued?

Uh huh, I understand how the union query works (I think) - union all allows duplicates which I would certainly expect to see in the result set. What I'm asking is, why would adding the same table in twice, but with criteria in the second select statement, seem to reduce the result set?

Afternoon campers, I have a head scratcher..... This union query is a bit strange:SELECT [Full Sales History CY-0 AEM].Month, "AEM" as Region, "CY-0" as Period, [Full Sales History CY-0 AEM].SalesOrg, [Full Sales History CY-0 AEM].Material, [Full Sales History CY-0 AEM].[NS(F)], [Full Sales...

Try debt.value instead - assuming that's the name of the control, not the field name in the underlying table. You've also got 2 end if's there, and you've spelt customer as cutomer.... but VBA would have thrown thowe up as errors anyway I expect :)

Yeah, bit clunky but you could easily just delete the table after the transfertext is done, keep it neat on the face of it :)

Try an if in the afterupdate

Could you use the recordset to make a table, then use transfertext that way?

You could do it in the afterupdate event of a control if you like - select the value you want in the combo box, then in the after update putcustomerdebt.value=comboname.column(x)Where X is the column number starting from 0.

Put "Is Not Null" in the criteria, should work OK.

Tagged is a checkbox on the form (in continuous view), fieldname points to a field in the underlying table. It's supposed to average out the values that are selected with the check box. Other options in the combo boxes mentioned use sum instead of avg, they work OK.

Afternoon all.... Happy Friday! I've got a series of text boxes on a subform whose control sources are update using VBa, depending upon what the user has selected in some combo boxes on the main form. The control source runs along the lines of =avg(iif([Tagged]=True,[fieldname],Null)) but it...

Dunno, she seems the type to dish out some harsh discipline... oo er