Search results

So just to clarify, as I am still new to the functions in Access =iif ( len([field])=0, would be saying "If field has no characters input"? And how would I actually implement the "Chr" function? Just follow up with it like I would an HTML tag?

Hey all, I'm creating yet another report for this massive amount of educational data I've collected and need some help combining some of it into an efficiently built report. My desired outcome is simple: Instructor1---|Fallcourse1 & Fallcourse1Notes (if any)|WinterCourse1 &...

Happy Friday everyone! I got what is hopefully a simple problem: I have a ton of addresses and contact information that all use the same form letter. However, this database I've inherited sorts its data on different tables per the origin of the data. Example: Table: State Organization A...

I would like to thank a greedy hungry crow for my solution. This morning, I was walking to work utterly frustrated that I couldn't think of an elegant solution when I saw a very happy and presumably hungry crow with a dilemma -- The crow stood between 2 worms which were coaxed out of the soil...

I'll probably purge the data (confidential) and zip it up for ya prob in the morn tomorrow. Bend well if I don't hear from ya before then.

You know, that's what I told my temporary supervisor, but she REALLY likes this database that's already storing all this data and she wants to be able to push a button and pump out a report as shown above instead of wasting the DB and just copying the info into a spreadsheet.

Table Fields: Quarter (Fall, Winter, Spring) Year (2005,2006,2007,...) Course (Course1, Course2, Course3) Compensation (Money1, Money2, Money3) Professor (Prof1, Prof2, Prof3) Display Goal -------------------------Fall-------------------------------------Winter------------------...

This is almost a cross-forum post. I started a post in the reports forum to see if it were possible to sort/group the data by field values. Everyone knows this can be done row-by-row, but I was looking for a way to do it horizontally as well...

Further Developments: It seems as thought I am seeking the ability to crosstab Text fields. Is this possible?

Bump. Said I would bump with a better explanation. I think that little diagram best illustrates what I need. Each quarter is a value in a valuelist.

Hey guys, I'm having trouble wrapping my head around a concept when it comes to grouping and sorting. I want something like this: ...........[quarter]="Fall".....[quarter]="Winter"........[quarter]="Spring"........[Quarter]="Summer" 2005.....Relevant Fields........Winter...

Hey again all! Implementation is going fabu, but I had a request to add a button on the main form to open the HTML FAQ I wrote. I thought I would be able to quickly point the button to the file using the button creation wizard, but that doesn't seem to work so well. (not at all) Did I miss...

Rockin'. Will do.

Old Thread Bump -- Clarification Hello again, all. Ok, as I am still picking up on the vocab, I need some clarification on the above posts as I believe I have a similar problem. I completed a great DB for my Dept. thanks to this forums (beers all around!) and have had to work on it back and...

It seems to have worked. I'm drop in some dummy data (book orders from another quarter/year combo) tomorrow to see if it really does the magic. On a related note: Is it always better to base a report off a query as opposed to the table itself in case you want to drop such a function in?

To clarify: The functions of my database: Ease data entry complications (they used to use a spreadsheet with 42 columns) Easy creation of order request of text books for bookstore Easy creation of multiple forms of requests for desk copies of text books from various publishers Essentially, the...

Me again. *Disclaimer* I don't know the first thing about VBA or any other program language and am attempting to create a simple solution for a departmental problem. Ok, so I got a book order database set up now. The only weakness in it is that each quarter the records have to be dumped...

As I suspected. It'd probably be added as a feature in Access 2010. One feature per release, right? =\

Hello again, all. New request for my report (mail out) -- I need some stuff bolded, but the text is part of an expression making up a paragraph. Ex. "Blah blah blah" & [field1] & "more blah." I need Field1 to show up as bold.

I don't know if I missed something, but I've come across a problem where my form will not display any record info input past the 53rd record. Seriously, I'm populating this database and I get to 58 or so and skip back to #53 check a publisher name, go forward, and it's a blank record #54. I...