Search results for query: *

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...

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, 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, 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...

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...

Hi, I need to rank records. If the field [100%] is the same for more records (rows), the colums volume 2009-2011 are used for ranking. first the column volume2011 is used, the highest value gets the highest ranking. If they are the same as well, the column volume 2011 is used, and then volume...

Hi, I have a query the results in a calculated column with percentages. If there are duplicates in this column I need to identify them. So I tried a duplicate query which results in the mentioned error. If I use the duplicate criterie query it runs fine. I don't know what is the problem. The...

Hi, I'm looking for a solution for the following: I have a table with two datefields, the startdate of a study and the end date. The studies vary between 2 to 6 years and start and different months/days. I would like to fill a table with fields containing the months for each year that falls...

Hi, Does anybody know if it is possible to determine if a user clicks in a table or certain location in a Word document? (Word2007) If a cursor entry is determined a form should popup. Maarten EasyIT "Do you think that’s air you're breathing?

Hi, We want to migrate our old database into Act! 2008. Currently it is setup with separate db's for customers(4000), suppliers (500) and locations (900). These db's are not related. I wonder what is best: a single db and assign groups, or keep them split in act as well. Does anybody have...

Hi, I've posted the same question before, but since I have not found a solution yet, I try again. I've a text file that i want to import. Origin SAP-ISU. Due to the many spaces between the columns, it can only be imported as a fixed field. The problem is that at certain lines, two lines go...

Hi, I have a textfile that isn't importing correctly. Contract CRblk AanF Gem CR Product AanA AO Portie Instl Inhuis- Status1 Status2 Geblokkeerd Aanpassings Normaal 3005568961 XX F 1 5033468881 NG A 01 KC0907 6012456690...

Hi, I'm having trouble getting a query converted to SQLServer. I've the following query in MSAccess: UPDATE ZIS0181_import INNER JOIN [SELECT ZIS0181_import.contractrekening FROM ZIS0181_import WHERE (((ZIS0181_import.Status2) Like "*X*")) OR (((ZIS0181_import.Status1) Like "*X*")) ]. AS...

Hi, Importing a text file into a linked table causes a numeric overflow. The odd thing is that when doing the import into the same table when it is not linked (ie. it is in the DB) it is no problem at all. The whole import routine worked fine for the past year (daily base), but not since the db...

..of of 2005-52. Which in itself is logical but not what I need. How do you get the right week with the right year?

The query is rather big so I would like to keep it in the query designpane instead of building it up in VBA. SoI have a existing query with parameters and I need to test in VBA (pref. ADO) if it has any records. Seems simple, but I don't know how to solve this. Anyone with ideas? EasyIT

Hi, I thought I had it figured out nicely, but I ran into something new. I secured a db (fe & be) under winXp using access 2000. The DB is developed in a2000. It is properly secured, I cannot open it without system db and login/pwd. However, when I transfer the db to another pc with a2003, it...

Hi, I use the following to retrieve all email entries in a mailbox on the exchange server: Function RecursiveFolderSearch() As Boolean On Error GoTo Error_Handler Dim i As Integer Dim MyMapiFolder As Outlook.MAPIFolder Dim conn As New adodb.Connection Dim rst As...

Hi, I have an access application that generates a excel sheet (background, not visible). This sheet is from a template which pulls data from access using AD. All works fine, but I would like to show the Accessuser the progress of the excel sheet. So I was wondering if it is possible to write...

Hi, I'm new to project en struggeling to get the amount of hours that are assigend to a task distributed to a resource. After leveling, a task with two subtasks with each 8 hours of work to be done, is being scheduled to 8 hours per day over a period of several weeks, because there are other...