Queries

Updating values from the previous record
I was using Allen Browne's module to update values from previous record. The entire code could be viewed at the following address: http://allenbrowne.com/ser-24.html It updates every field. You can exclude the fields that you don't want to be updated by naming them in the before insert event of t... 5 May 2010 01:44

grouping issue with ' is not null '
Hi All, This first query all works fine, giving the expected results. The second query is a copy of the first query and i changed the " IN " to " OUT ", but this gives an error if the line ' HAVING (((gamrep.Out) Is Not Null)) ' is missing. With this line in the query does work but the result is no longer grouped ... 5 May 2010 12:40

Combobox Dropdown jump to selections starting with E's
Hello, I have a combobox field with selections starting from A through Z. When I click on the combobox I need the drop down to skip down to the E's - Z's. In other words skip all the A's, B's, C's, D's and start with the E's. I still want the ability to scroll up into the A's through D's. Could you help me w... 8 May 2010 23:16

cdo or objmessage??
I developed a 2007 database, in which i have dozens of runtime users. because of this, we ran into missing reference issues. All of them I corrected, but one. In the database, I have an auto email goes out if a textbox is >0, using the docmd.sendoject method. But that gives the runtime user: missing or broke... 4 May 2010 16:51

QUERY FIELD SUM
In have the following in my first field. K:IIF([PL4HX4.RK]=1,"2",IIF([PL4HX4.RK]=2,"1","")) I have the following in my second field. H:IIF([PL4HX4.RH]=1,"2",IIF([PL4HX4.RH]=2,"1","")) What would i write in my third field to get the sum of K + H ? Thanks ed ... 6 May 2010 15:24

Left Join query not working in Access 2010
Hello, I have a query that works correctly in Access 2003, but not in Access 2010. Here is the SQL: SELECT qrySysSelectEeSS.EmployeeID, qrySysSelectEeSS.Name, qrySysSelectEeSS.ListOrder, Sum(IIF(tblPRItem.Preserve,1,0)) As CountOfPreserved FROM (qrySysSelectEeSS INNER JOIN tblPRItemPayWork ON qrySysSelect... 4 May 2010 15:42

Function is not availalbe in expressions in query expression e
Strange. I can only see a single . in the original message. I'm using the web interface so that might be a factor. On the other hand no one else has replied to your original message so maybe I'm not the only one. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycl... 4 May 2010 14:35

Filtering records by date
Yea I'm trying to filter a table that has specific due dates, but I want to run a query that will show the results 7 days before the due date and not show all the records just the records that have the due date 7 days prior to the due date. Also wondering if anyone knows how to make it where the query could se... 4 May 2010 16:51

Function is not availalbe in expressions in query expression error
The subject line gets cut off after a few dozen characters. Please post a more detailed description of the problem down here in the Message area. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "repent34(a)hotmail.com" wrote: . ... 4 May 2010 13:28

Duplicate prompts in crosstab query and subsequent report
I have a crosstab query in which I am prompting for a date range (Between [Enter Start Date] and [Enter End Date]). When I run this report it prompts me multiple times for the date range. For example: I have a report pulling from one crosstab query which contains 10 graphs. The report prompts me 10 times ... 4 May 2010 12:21