Search results

Also, thanks for the suggestion and tutorial link.

I apologize! I also posted to: http://www.tek-tips.com/viewthread.cfm?qid=1720593 Thank for the explanation link.

I see. The advantage of muti tables would be in normalizing the database, since so many of the types and periods are repeated. In different combinations though.

Hi, Wouldn't I end up with the same number of records (50ish) in the one table to capture all combinations of type, period and notes, and therefore just have a different version of what I currently have? Or, maybe I don't see the difference of your suggestion.

Hi there, My dilemma is deciding if setting up my particular data in separate tables would be beneficial or make revising this data on an as needed basis by an end user more complicated than if were to store the data in one table. My data is approx. 50 different records retention periods, which...

Calling all experts! I need your help! I need to create conditional formatting (like highlighting) for multiple field values that do not match in my report that is based on a Union All query. First, you might need to know that my Union All query (detail below) returns all rows in tables A and...

Found a solution, more at my level too: Mid(IIf(Len(Expr1), ", " & Expr1, "") & IIf(Len(Expr2), ", " & Expr2, "") & IIf(Len(Expr3), ", " & Expr3, ""),Len(", ") + 1) thanks though, appreciate your help!!

Hello there, I’d like to combine the text values from multiple fields from one table in one new field, for each record, and null values are involved. There are really a dozen fields to combine, but to make discussion easier, let’s say I have 6 fields to combine: Expr1 Expr2 Expr3 Expr4 Expr5...

Yes! That's it. Thanks!!!

What is the Cdbl for in the IIf(Cdbl([3 laboratory... formula above?

Hi! I am having trouble with a formula in the Update to: of my update query. I can get it to update a date field in the underlying table with this formula: DateAdd("yyyy",([table1]![Number1]+[table1]![Number2]),[table2]![Date]) but, if a check box in another field is checked, I want the...

Okay, thanks! I think I got it. Let me ask: if I have a list box on my form based on table 1 and I link that to table 2 (one-to-many), and I make a multiple selection in the list box, will the selection be stored in table 2 as you suggested? I give it a try!

I am having the same problem! In my case, I have one description that may have multiple sub descriptions that apply to to one record. How can I select more than one option from a list box and be able to carry the whole selection to the underlying table? When I change the property to allow...