Search results

This is an Excel form, and just noted this site is for Access. I can take it elsewhere. Appreciate the quick response!

I have a vb form the reads a list of group names in from sheet 2 called GrpName. It has approx 50 rows. I created a combo box to allow for them to select the name needed. It was working until yesterday, and now it is only showing like the first 25 or so. Nothing has changed on the code. Suggestions?

Ok so here is what i did and it worked Test2: Nz Worked great!

Yes and i get a parameter box but when i try to take expr out it adds it back

So it would look like Field: new field name = nz (

That is not my key joining fields. I have two tables and I join them by c,d and e. I just need a to come from one table or the other. Would I need to do that outside of query design?

This is what I have Field: flag Table: A Show = yes (flag checked) Criteria: Nz([a].[flag],[b].[flag]) Doesn't seem to work. Did I miss something?

I have two tables with the same field lets call them a.flag and b.flag. I am making a join query of these two tables, and need to add a field that create an if.then.else criteria. If table a.flag is blank then b.flag else a.flag.