Recent content by poporacer

Awesome, I appreciate your explanation as well, it works perfectly!

I have a table (tblLeaveData) with the following fields PERNR (Long) LeaveDate (date) SickType (text) DrNote (YesNo) SickType will have the following values: "S", "SF", "SD", "SFD", "SPre", "SFPre", "FM" I need a query that will filter out any "SPre" or "SFPre" where the corresponding DrNote...

plog, no the date criteria is different so I can't separate it out... In regards to the DateAdd, I haven't found a way to get the first or last of a month without using a combination of 2 functions (DateAdd and DateDiff) when I can do it with one DateSerial function. If there is a better way...

Ok, so I figured it out.... The Count function counts all records that have a value, so when I use the IIf statement I was setting it to 0 or 1 thinking that it was only going to count the 1... But because 0 is not null, it counts that entry as well. The solution is to either change the Count to...

I think I am getting closer. I restructured the queries and If I can get them to work I think I can combine them. Here is what I am having problems with. This query is not returning the expected results, It returns the total number of records for each employee it doesn't filter out the date or...

I attached a sample database with data and the separate queries. So what I need is a query to return the formula based on the included queries. Here is a description of each query: qrySFFirstPart=total number of SF Sales from the non-reported period last year. qrySFSecondPart=total number of...

I have a report that I need to show only the employees that meet a certain set of criteria. There are 3 tables used for this report. The first table is the Employee table that gives the specifics of the employee. The second table is the Sales Data (tblSales) that has the employee ID, Sales date...

Thanks, it works perfectly... I don't know why I didn't think of that.

I have an Access database with a button on a form that when the user presses the button, there is some VBA code that checks to see if Excel Is running, opens Excel, get the data from the spreadsheet and then closes excel if it wasn't open before. The problem is that when this process is...

That is plain weird... I looked at the code that I copy and pasted and that line is in there. I am not sure why it didn't post unless I accidentally deleted that line after I pasted it in my post. My version is slightly different Set oXLApp = GetObject(,"Excel.Application") I have a comma in...

I have a form that calls a function in a module that opens a spreadsheet, looks at the value of one cell and returns a variable. Then the code continues and does a similiar thing. I call the function in the Module from several different forms and that is the reason I have it in a module. The...

Thanks... I changed the logic to IIF and it worked!

I have a field that I need populated based on a couple criteria. The report is based on a query. I can get close. From my understanding, a Switch statement will return the first True value, but evaluate all expressions. I can't get it to work quite correctly. The query has a field VacBid that...

Does the Windows 8 machine have more than one version of Access installed? Or is it possible that you have the wrong version of Runtime installed (or more than one Version of Runtime installed? Access doesn't get along with itself if more than one version is installed.

Sorry if posting to more than one forum is wrong. I just haven't seen the answer I needed... I know what I need is possible because another database (not developed by me) has the functionality I am looking for. I will continue with my research. Thanks for your help