I need help with Date Parameters and Access

[tthai826]

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 tried something like this"-1" in {Part Master.PRTNUM_01} or
"-2" in {Part Master.PRTNUM_01} or
"-3" in {Part Master.PRTNUM_01} or
"-4" in {Part Master.PRTNUM_01} or
"-5" in {Part Master.PRTNUM_01} or
"-6" in {Part Master.PRTNUM_01} or
"-7" in {Part Master.PRTNUM_01} or
"-8" in {Part Master.PRTNUM_01} or
"-9" in {Part Master.PRTNUM_01}

As my formula, but the result I got was as follows.
20943820948-12
23424332434-1
12431221312-13

Where it pulls up both single extensions and double (triple aLSO), how do i isolate it so only -1,-2,..etc comes up?


2. I'm trying to retrieve part id numbers by the dates that they were entered and /or the dates they were last edited. Please help out if you can.

 

[MrBillSC]

tthai826,

To select the records you want, create a formula field called @hyphen that looks for a "-" as the second to last character:

Mid ({Part Master.PRTNUM_01},Length ({Part Master.PRTNUM_01}) - 1,1)

Then use the select expert to select records where @hyphen = "-"

Could you give more information about the dates? Are you going to prompt the user for date ranges?

MrBillSC

 

[tthai826]

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.

 

[tthai826]

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.

 

[tthai826]

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