Queries

Update Query
Hello, For every record in a table I need to update one of four Yes/No check box fields based upon date span. If the "In Date" is in the same month as "Serve D" or "Return D" field place a check in the "DispodWithinSameMonth" yes/no field. If the "In Date" is within 30 days of the "Serve D" or "Return D" f... 8 Mar 2010 14:10

Unable to use filter in datasheet view or add criteria to query in design view
HouBMan wrote: I have a question regarding a custom function. The query results can't be filtered nor can a criteria be used in the design window to filter/ restrict the records. The function returns the correct answer for all the cases but I need the functionality to filter the results. Here is purpose, i... 3 Mar 2010 11:51

IIF Record =
I'm trying to update a query expression and not having much luck. The origional expression pulled a value from a Form and then based on that value summed the values from another table. Month08: Sum(IIf(Forms![Summary Reports]![Report Month]=8,[Sep]+[Oct],0)) Now I want to point this expression to another tab... 3 Mar 2010 19:48

Unable to use filter in datasheet view or add criteria to query in design view
Hello all, I have a question regarding a custom function. The query results can't be filtered nor can a criteria be used in the design window to filter/ restrict the records. The function returns the correct answer for all the cases but I need the functionality to filter the results. Here is purpose, input and... 3 Mar 2010 10:41

Help please with nested iif
Hi I am trying to create a nested iif, for the following scenerio - but I am having difficulties if due date is less than today, show yesterdays date. if due date is between today and today plus 14 days, show the current due date. if due date is greater than today plus 14 days, show the current due date plus... 3 Mar 2010 06:16

QBE
I have recently started using Access 2007. I like to arrange fields in a particular order when I create a query. I have noticed that if I create a query, then uncheck the "show" box on some of the fields, that the next time I go into the query (in design mode), all the unchecked fields are at the end of the Q... 2 Mar 2010 20:24

Database shutdown after idle time
Is it possible to automatically shut down a database if a user has it open but it has been idle(not worked in) for say 10 minutes. I have 5 user groups in a database and one group is forever leaving it open not allowing the other groups to enter data into the tables, so if I could have it automatically shutdow... 2 Mar 2010 22:37

Query Question
Hello, I have a query that i would like to filter when i click a button on my form, that uses a field on the form to filter the query. I do not to display info in a report or form, or table but to export to excel. i cannot figure out how to do this....any help would be appreciated. Ryan ... 2 Mar 2010 14:41

crosstab query child table count
I have a crosstab query and would like to count parent and child tables like following: Select tblParent.Parent, count(tblParent.PrentID), (Select count(tblChild.ChildID) where tblParent.ParentID = tblChild.ParentID) From tblParent Group By tblParent.Parent It seems that MS Access does not allow to do thi... 19 Mar 2010 09:19

Return all dates for 'next month' irrespective of year or day
Hello, Sorry to ask such a simple question; I would like my query to return all rows were the my 'date' field is any day in the next month. The year & day of month are not relevant. I have been getting stuck using (DatePart("m",Date())+1), this works fine except on December at which point the expression retu... 2 Mar 2010 14:41