Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help! Need to set up Access query that omits blank fields

Status
Not open for further replies.
BigFizil

BigFizil

MIS
Joined
Mar 9, 2003
Messages
23
Location
US
trying to set up a query that returns only fields with data if empty or null it omits it in the results...

please help!
 
Sort by date Sort by votes
what are your fields? what does your query say so far?

you can make the query criteria "Is Null" or
Code: 
=""
or if you want to exclude, "Is Not Null" or
Code: 
<>&quot;&quot;
if that doesnt help please give more info.
 
Upvote 0 Downvote
Well I have the query linked to a form that I search by 6 different criteria....

I am using this form for each criteria.


[Forms]![Product Development Search Form]![cbopstat] Or NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;) = &quot;&quot;

but I am wanting to add picture functions and certain items dont have a picture and I want the query to only return the items with a picture....I have tried the IS NULL and IS NOT NULL and it doesnt seem to be doing anything for me it still returns the field....is there a way to OMIT if the field has a default value such as &quot;NONE&quot;

OMIT field IIF = &quot;NONE&quot; ??

Please help and if you need any other info please let me know.

Cordially,

John
 
Upvote 0 Downvote
hi john:

when you put this:
Code: 
 Or NZ([Forms]![Product Development Search
                         Form]![cbopstat],&quot;&quot;) = &quot;&quot;
 you are essentially saying &quot;And show me everything that is null too&quot; which is opposite of what you are wanting.

why not just use
Code: 
[Forms]![Product Development Search Form]![cbopstat]
only? i must be missing something. how is it designated some place if an item 'has a picture' or not? is cboPSTAT like an ID number or something, that is joined to some other table where there are muliple records with that PTSAT number, some of which do not have a picture? whereever it is indicated that there is a picture, put IS NOT NULL in there. even if it is the ID number of a 'picture' table....maybe i'm just way off the mark. give me more details.....
 
Upvote 0 Downvote
Basicaly the NZ statement is there so if the combo box on the form is left blank the query ignores it and returns the other boxes input....
 
Upvote 0 Downvote
Also...I set up NULL query with only one field and it works for some reason the other stuff just doesnt mesh well....
 
Upvote 0 Downvote
if the combo box is left blank, you will get all rows returned. it will not do what you think it will do.

i still do not understand your whole issue.
what happens when you put 'is not null' in the criteria? it should only return rows that have something in them. i am totally lost. please paste in your SQL string.
 
Upvote 0 Downvote
get ready for this beast.......

SELECT Development.[Revision A cad], Development.[Revision A], Development.[Kinder Number], Development.Date, Development.FAMILY, Development.FIXTURE, Development.[Active/Obsolete], Development.[RND #]
FROM Development
WHERE (((Development.[Revision A])<>&quot;&quot;) AND ((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd])) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;)) OR (((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[RND #])=[Forms]![Product Development Search Form]![cbornd]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Active/Obsolete])=[Forms]![Product Development Search Form]![cbopstat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.FIXTURE)=[Forms]![Product Development Search Form]![cbopcat]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.FAMILY)=[Forms]![Product Development Search Form]![cboprofam]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.Date)=[Forms]![Product Development Search Form]![txtdate1] And (Development.Date)=[Forms]![Product Development Search Form]![txtdate2]) AND ((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((Development.[Kinder Number])=[Forms]![Product Development Search Form]![cbokinnum]) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;)) OR (((NZ([Forms]![Product Development Search Form]![cbokinnum],&quot;&quot;))=&quot;&quot;) AND ((NZ(([Development].[Date])=[Forms]![Product Development Search Form]![txtdate1] And ([Development].[Date])=[Forms]![Product development Search Form]![txtdate2],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cboprofam],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopcat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbopstat],&quot;&quot;))=&quot;&quot;) AND ((NZ([Forms]![Product Development Search Form]![cbornd],&quot;&quot;))=&quot;&quot;));
 
Upvote 0 Downvote
geez.
have you tried a simple query for testing, where you use that formula NZ([forms]!ProductDevelopmentSeachForm![cbornd],&quot;&quot;)=&quot;&quot;?? do that on JUST ONE FIELD and you'll see how it's not doing what you think it should be doing.

this returns ALL records if the cbo box on the form is blank. i think this is the key to your problem.

how big is your db after compacting and zipping? you can send it to me if you want: rowe147@hotmail.com (2MB) if too big maybe you can make stripped down version with just your query, form and table in question.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
872
mikrom
mikrom
serino
  • Locked
  • Question Question
Help with a Query.
Replies
13
Views
1K
strongm
strongm
C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
749
dhookom
dhookom
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
605
mhshane
mhshane
breezett93
  • Locked
  • Question Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
780
breezett93
breezett93

Part and Inventory Search

Sponsor

Back
Top