Search results

Thank you all for your help. I did use the syntax Iif(([employee name]='X' OR [employee name]='y') AND IsNull([Notes]), "pending") This gave me the results I was looking for. I appreciate everyone’s assistance with this question.

I really wasn't very thorough, sorry about that. I'm just trying to create a syntax that compares two record fields with three possible resolutions. If employee name is X or y and Notes, (a different column) is null then return "pending". The pending result is a prompt for us to complete the...

I know this is likely a simple issue that i'm overlooking but i'm not getting the results i'm expecting to see. CoverageStatus: IIf([employee]="X" or "Y" and IIf([Notes] Is Null,"pending","")) The intent is to use this calculated result to reference on a report for conditional formatting. I'm...

I'm extremely new at using crosstab queries so i'm probably either taking unnecessary steps or doing this the hard way all-together. As you speculated, i'm trying to set up a query for reporting purposes and by the way it sounds, crosstab is not the best way. I used the month as a generic as...

I've got a crosstab query set up as followed: Month: Row Heading Shift: Column Header EmpIDCount: value I have two questions regarding this same query which hopefully would apply to all future crosstab queries I build. Question 1: My shifts read as followed: Days, Swings, Mids In my query...

I'm afraid i'm having difficulty understanding this application. In my previous post, I explained the wrong table while addressing the question but still looking for the same result. I'm now attempting this on a form for my tblemployee table. The table holds the following entered by the...

I've got a form which holds data for employees, fname, lname, ..... and an entered date which defaults to now(). On the before update event, i have the following. If DCount("*", "trainingdata", "[Empid]=" & Me!EmpID & _ " And [subjectid]=" &...

Thank you very much Galaxiom, I tried all sort of variations in attempt to get the result I was looking for and for some reason, thats the one thing I didnt think of. At least I was close. Thanks again for the help, your prompt response was much appreciated, i've been brainstorming this over...

I'm trying to build a query with an iif statement to calculate expiration dates within a query. For some reason what i'm trying to do is not working as expected. Here's the situation. Every employees with an exception of two employees in the company has an expiration 2 years after the class...

Gentlemen, Sorry about not getting back sooner, I went to work shortly after I posted and haven't gotten to get back to it until now. The bad news is I would have to agree with your reply, I just read it again myself and see how I should have worded most of it differently to describe what it...

I'm trying to build a report which will eventually be used as a subreport. I've got the general design of the report completed but now i'm having some issues with resolving further settings. The report consists of training classes and dates an individual participated in said training classes...

HMMMMMMM, above my level of experience i'm afraid :(. Sorry.

I just realized as I was responding initially, someone else has already responded; so hopefully my input is not redundant. In any case, if you want a final report or such that shows all of the data in the table with only the "Max" balance, you will create a query that looks like the...

I worked my way through this exact situation yesterday; however my situation was a little more complex. In any case, if you just want to find the highest "balance" for each individual person you will need to change your query a bit. On your query remove the "stock item" so you only have the...

I have the above noted code behind a button right now, I made the change indicated by Mihail and its still giving me the same error. Any suggestions.

I've got a macro that converts five separate reports to .pdf files and saves them to a specific folder on the desktop for later use via button in a form. These .pdf reports are intended to be used for reference on a portable device in the field. What I am trying to do is create a single button...

It appears as though I was overthinking that, I just switched the CF's that I was already using and made the "canceled" CF priority and it did exactly what I was needing. Thanks for the answer. :) Sometime I make even the simplest things harder than they need to be...

That's the issue, how do I make a condition that applies to two separate fields. I presume I need to apply an if/and statement; however I'm sure I'm not doing it right. giving it a shot here is what I came up with. iif([Covered By]="open open" and([Status]="canceled"

I have a report with multiple fields and currently have two conditional formats affecting this report. CF1: Expression is [Covered By]="open open" - Highlights associated records yellow. CF2: Expression is [Status]="canceled" - Highlights associated records red I came across a situation...

nanscombe, Thank you very much for the help, its much appreciated, that's exactly what I was looking for and trying to do. I currently have a macro that imports two different tables so the table times would likely be the same anytime the update is completed. If I break that up, is there a way...