Search results for query: *

Did you consider using distributing access runtime? EasyIT "Do you think that’s air you're breathing?

Hello Duane, Yes, but I do not need a sum. The individual values are wanted. Maarten EasyIT "Do you think that’s air you're breathing?

Hi, I have a query: SELECT q_NM_QUOTE_ITEM_MXA.NUON_ACCOUNT_ID, q_NM_QUOTE_ITEM_MXA.QUOTE_NAME, q_NM_QUOTE_ITEM_MXA.[SALES FEE], q_NM_QUOTE_ITEM_MXA.[Margin Fee], q_NM_QUOTE_ITEM_MXA.[ES Profile Costs] FROM q_NM_QUOTE_ITEM_MXA GROUP BY q_NM_QUOTE_ITEM_MXA.NUON_ACCOUNT_ID...

Solved it... Stupid me... My query was the base of another that was the source for the report. EasyIT "Do you think that’s air you're breathing?

Hi, I have a query that returns on or tw records. If two, the report is OK, each record is shown (by EAN). With one record, I also get two records in the details section, duplicates. This messes up totals of course. I fail to understand how this is possible, anybody got a clue? The report is...

Hi, Would running several queries in VBA be sufficient? If so, create the necessary queries, the execute them in the right order. docmd.QpenqQuery ("queryname") Maarten EasyIT "Do you think that’s air you're breathing?

Duane, Thank you for the reply. I knew about that solution, it wasn't working for me. I have solved it by using a table containing only one record, (the column name) i.c.w. a different query approach, not using crosstab but a select query. Regards, Maarten EasyIT "Do you think that’s air...

Hi, This is my query: TRANSFORM First(tbl_beschikkingen_cono.type) AS EersteVantype SELECT tbl_beschikkingen_cono.fk_stud_pis FROM tbl_beschikkingen_cono WHERE (((tbl_beschikkingen_cono.jaar)=(Eval('[Forms]![FormNEW]![cmbJaar]'))) AND ((tbl_beschikkingen_cono.fk_stud_pis) Is Not Null)) GROUP...

Hi Duane, Thank you for mentioning this possibility. I have already implemented the VBA option, but will experiment with thsi as well. regards, Maarten EasyIT "Do you think that’s air you're breathing?

OK, if thats the case I'll switch to VBA. Thank you all for the responses! EasyIT "Do you think that’s air you're breathing?

Maybe my question isn't clear enough; the values in the combobox are the field names of a table. Instead of writing the SQL in VBA I would like to get make the field name in the select query variable. Is it possible at all? EasyIT "Do you think that’s air you're breathing?

Even so, when used as a criteria it works. Or even if used as field it will return the string that is selected in the combobox. So it seems (almost) possible to use the string as a field in a select query as well. EasyIT "Do you think that’s air you're breathing?

It is a query, isn't it? EasyIT "Do you think that’s air you're breathing?

hmmm, not sure about that... EasyIT "Do you think that’s air you're breathing?

Hi, I have a form with a combobox. The combobox third column contains a textvalue that I would like to use as a fieldname in a query. Is this possible? I use this for returning the combovalue (Eval('[Forms]![frm_Main]![cmbCustomer].column(2)')) The table name is P. I tried Expr1...

Golom, Thank you, that works excellent. Maarten EasyIT "Do you think that’s air you're breathing?

...it is prompting for q_exchangerate!ExchangeRate. I tried to prevent the full sql, there are a lot fields. I reduced it somewhat: SELECT [tbl_pim_itemlist]![Sales FOB]*[q_exchangerate]![ExchangeRate] AS [Sales FOBk], tbl_pim_itemlist.MasterKey, tbl_pim_itemlist.[Sales FOB]...

Hi, I have a query the holds a singe value, an exchange rate. I would like to have a second query that uses this result to calculate the proper value. So the calculated field would becom: Sales FOBk: [tbl_pim_itemlist]![Sales FOB]*[q_exchangerate]![ExchangeRate] where tbl_pim_itemlist is a...

hmmm Tried to create duplicate records query, which works fine. Then another based on the latter. Than results in a "unknown Access Error". And a third query finding the dups in the second also ofcourse. Is there a limit on building duplicate queries? FIRST: SELECT [TW2013_2B-b_1].[sector...

...within each [sector opl] the [100%] score (which in itself is already a calculated field). It is not alphabetical, the ranking translates to money in the end... ordering by names would make some people angry. EasyIT "Do you think that’s air you're breathing?