Search results for query: *

alright, sorry for the misterms. I'll try and put this out as best as I can. The data I want to extract comes from {Part Master.SERTRK_01} {Part Master.PRTNUM_01} {Part Master.PMDES1_01} {Part Master.PMDES2_01} In SERTRK I want only the values that are "N" in PartNumbers I only...

Example Data S/N Control Partnumber N K000001 Output Data S/N Control Partnumber N K000002 Basicly searching for partnumbers in the system that are finish goods, bill of materials that have the sn control checked off.

CR 8.5, database used, index, part master. expect output is False (no s/n control sertk_01) only scanning completed boms (k numbers) Not sure if all that came out right, i'm still REALLY new to all of this. My apologies.

I'm trying to basicly get query out that will search SERTRK_01 for Knumbers (boms) that don't have the serial checked out. so I think it should be true or false. also display the part number and description. When i just setup the regular value, it displays all partnumbers showing Yes and no, but...

Need to search the part master for part numbers that end with a 1028-01A, 1028-02A, 1028-01B, 1028-02B, or W (ex: 234293W) I'm running CR 8.5, any help plz?

I'm using CR6, I don't think it has that feature yet. The way I was thinking is that it might still be possible to do it using multiple subreports

this all will be done in CR. the format for this consists of 4 diff subreports and one main one that will tie them all together (correct me if i'm wrong) the first one will be the bill of materials, then the mechanical parts (with attached part id's and descrips) mic part. then associated mfg...

I'm trying to make out a query that will have alot of information on it, concerning many database fields. I've been working on this for a few days and can't seem to figure it out. What i'm trying to do is make a bill of material that has also the mfg part number and mfg part description. plz...

i TRY doing that but I can errors.

What I'm basicly trying to do, is make a query that will search for part id's in the part master that have blank descriptions. I've tried several attempts concluding in failure. can anyone out there help me?

thanks all it worked. i'm really new at this. all your info helps out greatly

alright, this is what i'm trying to do exactly. I'm trying to pull up stored data as follows. only the part id's with lower case descriptions. Rec No. Part Master ID. Description xxxx xxxxxxxxxxxxxxx xxxlowercasexxx having the part id number in there with the descriptions is very...

That lowercase search kind of worked. I just want it to be restricted to only searching for lowercase.

I need to extract all the part master id descriptions that are in lower case so they can be edited to be in all uppercase. So My question is how can i go on doing that, or is it at all possible to enter in a formula where it'll automaticly render all the descriptions that are in lower case and...

hey, i got the @hyphen thing to work, thanks a bunch for that

acutally i just got your formula working for the "-", its pulling out part id's with a -01, -02, -03, where i'm trying to get the singles like -1,-2,-3.

well i tried what you showed about the @hypen, but it didn't seem to work. with the dates thing. I'm trying to get it so when the user is prompted for a date and enters one. alll the part i'ds that were edited on that date until present are listed in the report.

This will probably sound like a newbie question to everyone. But I just started learning how to use CR. there are two main problems I am having. 1). The first problem is that I am trying to get a report out that just outputs the partnumbers with a dash and a single digit extension., so I...