Search results

When I do DateVaule() and run the query, I get #Error? Here's the query: SELECT DateValue([ci_issue_status].[CS_CREATE_DTS]) AS Expr1, Count(ci_lookup_status.CL_Status) AS CountOfCL_Status, ci_lookup_status.CL_STATUS FROM qryStatusMaxDTE INNER JOIN (ci_issue_status LEFT JOIN ci_lookup_status...

I'm looking for a function in Access 2007 that will allow me to run a query that for a date field will only return the dd/mm/yyyy, and strip the time that is at the end of the line. I've done some searches, but all I've been able to come up with is Trunc(), which apparently is only an Oracle...

oh, and as far as normalising the data, I have no control over the DB, or the tables...I'm just "allowed" to do datamining and pull reports.

Thanks. I'm trying to do the subquery using the MAX function, and i'm having no luck. I have a simple query that is returning the MAX for the created date, but the second I try to put it into a subquery and add cl_status, it seems to remove the groupings. My simple query is this SELECT...

I have what should have been a relatively easy Count() query that I just can't get to return the correct information. Here's what I have: SELECT ci_lookup_status.CL_STATUS, Count(ci_lookup_status.CL_STATUS) AS CountOfCL_STATUS FROM ci_issue_status INNER JOIN ci_lookup_status ON...

NEVERMIND. Google is a wonderful thing. :-) I put a If me.Dirty Then me.Dirty = False In right before the openform. THANKS!

Thanks for the reply. I tried putting in DoCmd.Save before the openform, and got the same error. When I googled the docmd.save syntax, it apparently only saves changes to to form, and not the current record? How do I tell it to save the record prior to opening the new form? And I'm...

I have a field called status, and on the "After Update" Event procedure, if the status = closed or iATO a separate form pops up asking for what date the system will expire. The pop up works great, but when you go to close the main form, you get a message "The record has been modified by...

Is there anyway to force anyone in an access database out? We have a locked access 2007 DB that I have visually confirmed no one is in, but the lock remains. Is there any way to clear it? Thanks

I'm pretty new to Access, but have you just set the fields in the table to required?

I have a button called btnVendor that I want on click to open the form [Vendor Details] where the vendor is = value of the current record. So, I attempted this: Private Sub btnVendor_Click() DoCmd.OpenForm [Vendor Details], , , "Issues.Vendor = Vendor.ID" End Sub Currently when I click...

Excellent! Thanks, I will take a look!

I'd like to know if it is possible to setup a bar chart with conditions? What we want is if the field with_group: = group1, have the bar go out to a certain point on the x axis. = group2, have the bar go further out on the x axis = group3, have the bar go even further out (and so on and...

If they make you look like a newbie...then I must be the single celled organism that hasn't crawled out of the water yet. EVERYONE on this forum has been awesome and very helpful!

once again Bob is a GOD. I'm going to start putting that up on billboards like they used to do for Clapton.

When I try that, I get Undefined function 'DateDiffExclude2' in expression.

If I save that code as a module (called datediffexclude2) how do I call it in a query to see if it works for me? Thanks for the help!

I'm trying to run a simple query in Access 2007 to show the difference between two dates, but only have it calculate weekdays (I don't care about holidays). I throught doing "w" would only show weekdays, but it is calcuating weeks. SELECT tblWithGroup.[ID], tblWithGroup.[Issues_ID]...

Again, you are a GOD...and I bow down to your superiorness. Thanks so much for all the help!!!!

If it is null, I do just want to leave it alone, but couldn't figure out how to get it to do nothing...