Search results

IIf(Len([wintercourse1])<4,"",IIf(Len([wintercourse1notes])<>0,[wintercourse1] & " - " & [wintercourse1notes]& (Chr(13)) & (Chr(10)),[wintercourse1]& (Chr(13)) & (Chr(10)))) & IIf(Len([wintercourse2])<4,"",IIf(Len([wintercourse2notes])<>0,[wintercourse2] & " - " & [wintercourse2notes]& (Chr(13))...

I tried this expression in a field on the report and then just putting it in the query and I keep getting the same error as I listed above (2 posts prior). It's really bugging me because logically, what you suggested seems like it SHOULD work. Do you think it has something to do with the query...

I seem to have run into a snag. I'm pretty sure this would work otherwise: DLookup(iif(Left( [GenericFieldname1], 4) = "C101","Offered","NOT OFFERED"),"Generic Query") When I added this field/function to the query, I got #error values and when I clicked on one, I got an error that said: The...

I'm going to effectively kill this post since its relevance to the Reports section is questionable at best and move this developed question to the Queries forum where it belongs.

I seem to have run into a snag. I'm pretty sure this would work otherwise: DLookup(iif(Left( [GenericFieldname1], 4) = "C101","Offered","NOT OFFERED"),"Generic Query") When I added this field/function to the query, I got #error values and when I clicked on one, I got an error that said: The...

You're right about my lack of clarity. I was describing what the report itself would look like instead of what I would like to do to a query. I want to search an entire column for a value. If that value exists in that column, I want to output a value. Iif columnA contains Value1, then say...

MOVED DEVELOPED QUESTION TO QUERIES SECTION MOVED DEVELOPED QUESTION TO QUERIES SECTION MOVED DEVELOPED QUESTION TO QUERIES SECTION Hello again! Is it possible to append a summarized report of a report in a report footer? (Too much report?) I have a list of 40 or so records each with values...

Thanks super mucho. I would add to your rep, but apparently I need to spread the love before I can add to your rep again. You, sir, are one helpful person.

Hey all, I got a massive lump of WORD documents with Avery Mail label tables -- each avery mail label template/table has a mailing address. This how these people store their data. :mad::confused::mad: So I went through and over a couple days transfered all 458 records to an excel spreadsheet...

I knew that was the problem. When I first created the tables it was perfectly normalized. Then there was a problem with the most important report and the form and I couldn't find a way to make it work without rearranging the data as I did. (They want to be able to input all of a year's course...

(see sig for details on what I'm capable of before you toss code at me ;P ) Here's my current setup: Table1(Assignments) Instructor <related to Instructor table, pulls data from there) Academic Year Fallcourse# (where # = 1, 2, 3, 4), (course pulled from Courses table) Fallcourse#comp...

I think I would stab myself in the eye with a knife if I ever made it to 256 columns in a query considering I'm not getting paid big bucks for my databasing. I think I'm at 39 and only because it's easier for me to create expressions by first creating sub-expressions.

As per my reputation, I asked the question, got brave, tried out an assumption, and found the answer. No, there is no limit to the number of columns in a query if you use SQL. However, at least in 2003, there is a limit to the number of query columns you can use/expand to in design view.

Could anyone tell me if there's a hardcoded maximum number of fields/columns in a query? I ask, because through some experimentation and the urging of others on the boards, I've finally taken a look at the SQL view of a database and found it rather easy to understand. There, I found I had more...

It sure looks like it should work! But I don't code. Would you happen to know how to do exactly that, but via the query window?

Quick questions and I'm sure this is easy enough to warrant a quick response: I have a query. I have 12 different fields that may or may not have the value "Sabbatical". I want to view only the records that have the value "Sabbatical" in AT LEAST one of those 12 fields. Thanks in advance.

A win for the non-coder! I stared at the VBA code for a bit to understand exactly what it was trying to do. I stared at the grow-box explanation for a while and saw what it was trying to do and I figured it out for all of us non-coding Access abusers. Here's what I had and what I did: I had 3...

Dear KeithG, That is not the answer I wanted. /sigh. Ok, it's time to hit the books then. >.<

I know what you're thinking... there's a few posts on this already. There's the "grow box" There's this code here. There's the Microsoft Help explanation here. But this is all beyond me as it requires coding. I'm not against learning to code, but it's just not the best use of my time at the...

Using what nudges in the right direction were provided, I've come up with this expression so far: = IIf( Len([fallcourse1])=0,"", IIf( Len([fallcourse1notes])<>0,[fallcourse1] & " - " & [fallcourse1notes],[fallcourse1] ) ) & (Chr(13)) & (Chr(10))...