Search results

I know I should probably know how to put that to use, but would you be willing to put that in an expression? I am still rather nooberly to SQL. (I'll pick it up some day... promise!)

Hi again, I'm having a bit of trouble with these two concepts and am hoping someone could shed some light how I could use one or the other to get what I need: Have I have: FieldA, FieldB, FieldC, FieldD I need to count up all the fields that have "X" as a value in all those fields combined...

That's the magic! Thank ya kindly =)

Simple question: How does one reference a checkbox status in an expression? I have a bunch of checkboxes [FC1YN] through [FC4YN] and need to know how to reference them in an if/then statement. I thought "yes" and "no" values would be appropriate being that they are "yes/no" fields, but I only...

The records fields of the records by which I would like to filter are in a listbox/combobox, yes. I cannot anticipate by which values of the two fields my users would like to filter. I understand, conceptually, making a field and a button to permute data put into that field, but everything you...

Hey all! I've received yet another feature request for my main DB. A while back, I was trying to make a search form to filter the records in my main form. A kind fellow suggested I use the right-click menu and tell others to use the filter option in there. It's worked, but people would still...

Ha! Well this is going to be messy. ;) Thanks for all your help!

Ok, the first part of the where clause asks the user to type in the academic year of the report s/he wants to see. "2007/2008," s/he types in, and a report of a all kinds of different classes and grades pops up for that year. The second part of the filter is checking whether or not any one of...

ok, I've done the above and no dice. I have made a potentially important observation, though. When the expression: is entered into the query, the query spits out the appropriate numbers. All is good. However, once I add ">3" to the criteria/WHERE, the query acts like it's never heard of...

AcademicYear is Text because the values are "2001/2002", "2002/2003", etc. which all comes from a long story about the users wanting a very specific UI... but that on its own works great. GroupWinterBox et al. are aliases for expressions and your comment about possibly needing to use the...

Expressions in the same query.

Hello again my forum o' saviours, Current filter: AcademicYear is a field in the Assignments table (duh). In this same query, I have a couple fields (equations and if/thens built on the assignments table) that will need to be used as further filters. I thought something like would...

Thanks for the response. I'm going to figure out exactly what "join the lookup tables" means and I'm sure I'll come back to thank you for the solution in a bit.

Hello again, A while back, I asked about the now-removed function of exporting Reports to Excel. I was told that there's no way to do so in Access 2007 and that the best best would be to export the underlying Query. I did so and I found out that the query was showing the record number of...

Thanks for the lunch reading, Bob. =)

Alright, so my pride and joy and departmental savior database has been fully implemented and people are so pleased with it that they *all* want to use it at the same time. Initially, I made it custom for three peoples' UI preferences, but since it's such an intuitive design, other staff now feel...

Situation My database stores course information for faculty in my department and prints out various reports based on that information. The 2 mandatory fields in the form are [AcademicYear] and [Instructor] as they create the potential for classes to be added to the curriculum. Question Is...

HA! Thanks for that clarification. =) I saw the response right before I left work yesterday and went to try it out this morning. I couldn't figure it out because I was blind to the "on focus" option. When you mentioned it and I looked at it again, I just couldn't believe that I had been clicking...

Here's one for you guys: My vision-impaired staff are having trouble seeing the blinking caret when they tab over to the next field in a form. Is there a way to highlight the newly-selected field instead of just having a thin blinking caret to guide the way?

I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)". End result is Wednesday...