Search results

So does that mean that a record is only omited if ALL the fields are repeated?

Ok, this is a quote from MS Office online. So, from what I understand of this, if any of the fields in the record (or row, whatever) repeat then it is not displayed. Correct me if I am wrong. The problem is that when I try and use it in my DB it return all the fields regardless of the...

Thanks very much guys, that was helpful. The discussions on cascading combo boxes are what I was looking for I think. I also found an online help file from microsoft called 'combo boxes based on combo boxes' or something like that which was a tedious and comprehensive step by step intruction on...

Hey ladies and gents, Just so you know, I am new at this. You probably guessed. I am trying to learn how to make a specific type of form here and I feel like I am wading through an ocean of instuction books and help files, I was just hoping someone could point me in the right direction. Just...

I am afraid that isn't possible. I don't have control of the original tables or forms. My database is kind of an extention of one that was professionally built. The original database is able to make a user viewable version of itself but I can't actually change the way it works. So, the idea is...

Wow, seems like this is my favorite place in the world now. My problem is that I need to append data from one table to another, on the condition that any of the fields in the record have changed since the last time the query ran. For example, tblEmployee has the fields 'EmployeeID', 'Name'...

Done! I found a way to make a query that works. SELECT TOP 1 momsfav.MomFav, momsfav.StartDate FROM momsfav WHERE (((momsfav.StartDate)<=[Forms]![form1]![Text0])) ORDER BY momsfav.StartDate DESC; As you can see, it displays dates equal to or before the date entered, sorts them decending...

Murli, This in ingenious. I don't know how you came up with that. Still though, there is a problem. The queries calculate the closest date to the one entered, not the closest date before the one entered. For example, if you put in 12/12/2005 it comes back with Betty, who's start date is...

I need to know if it is possible to make a query that selects the highest or lowest value below or above a number that a user or form defines. For example, the attached database has a history of which of three children held the position of mom's favorite by recording the day that they became...

You can kinda see that I don't know what I am talking about. Anyway, done and learned. Thanks!

I just want to make sure I understand this right. Not In is a function and (select UserId from tblUserdata) is a query? So am I correct in assuming I could use more complex sql statements as part of functions?

Beautiful Murli. Worked like a charm! Thanks!

I am wondering if it is possible to use a table/field identifier as part of a criteria expression in a query. The field that I need to use in the expression is not a part of the focus table, so I think I need to use a full identifier, if that is possible. I have seen such identifiers used for...