Search results

I hope this is a simple question. I have two fields - DueIn (Number) and Approved (Date). What I need is if the user enters an approved date the DueIn field returns the value of zero after the update. The DueIn field is initially derived from a target date after the update, which is the...

Wait I think I answered my question. If I use a date field as to when the record was archived then in my query I say is null any associated records will not display. Like DUH! I know don't over think it.

I am faced with a similar situation. There are times when a course may be archived. I have a checkbox for the user to select if the course needs to be archived. Is there a way to deactivate all related records when the course archive checkbox is selected? For example, the course may have three...

Execllent! Thanks

I am back. Just when I think I a figuring something out....Nope not a clue! I have a temp query I created to get my SQL statement. I want to total the lesson duration for each course to determine my course Hours. The sum of lessons (lesson total) is related to the catalog ID. Currently using...

I am going to leave the code as is. It is working. I thank you for all your advice but I don't want to go and bother you by creating errors. I value your time more than wasting it.

Yes, I had only shown the first function in the original post. It is highlighted because it failed and when I clicked debug, it highlighted that row. This function counts all the events by Module. It is working as I had it written. I don't want to confuse things and be a bother. Being new to...

Now That I understand. Thank you. LOL :)

I have three functions CountEvents, CountAllEvents, Cduration The third function Cduration, is one I am still working on. I am trying to sum the lesson duration total to get the overall course duration. 'Used for Course Report to count the total events at the Module Level Function...

Sorry Edgar. I do not understand. I am new and learning. I have bought courses on line and been watching tutorials. I am attempting to learn what is a good practice and what is not. The code I posted was my first attempt at using SQL in VBA. Although I received the correct expected result I was...

I tried this but received the following error:

Sorry forget that code. Below is the correct code: Function CntAllEvents() As Integer Dim SQL As String Dim dbs As Database, rst As Recordset SQL = "SELECT Count(Events_tbl.EventID) AS [Event Count] " & _ "FROM (ListModule_tbl INNER JOIN ((Course_tbl...

I have written a function that counts my events using an SQL statement. I did this by watching various codes being written and putting it together. I would like advice on whether I have written the code to best practice. The code does work and gives the correct results. 'Used for Course Report...

I read an article that said I could put a query in my report footer to get the count accurate. Is this a good practice?

Is there a way to tell the report if the CourseID is blank don't count the record?

OK I am going to back up. I am going to start with the very first report before I start nesting. My Main report is going to list the courses by Module. When I get the report counting correctly my goal is to put in a prompt that requires the user to put in a catalog ID to filter the report to a...

Pat, I have tried that. The event report is my third nested sub-report. What appears to be happening is if there is no event for the lesson the event is showing up as a blank record and that blank record is being counted. It is like it is keeping a placeholder. I cannot figure how to get it not...

I am looking to get the event count from my event report ininto the Module and report footer. I need the report to show how many events there are by Module and then overall (by report). I tried to write the following, but of course I did not do well. I do have an event Count Qry, but I could...

Thank you for taking the time to explain.