Recent content by cstuckey

Please help. This might be a simple way to do this, but I'm not really good at coding so here it goes... I want to make a form or report when a person enter a vendor (example) the other fields will atomatically fill-in depending on the data that cooresponds to that vendor. Can you show me how...

Can you help me. I have about 2000 records with Part Number XXXCOGxxxxx. This Should be C0G. Ex: SPN RPE122COG101K RPE122COG681K RPE122COG101K RPE122COG681K GRM40COG100J GRM40COG100K GRM40COG101J GRM40COG150J GRM40COG220J GRM40COG221J GRM40COG271J GRM40COG470J GRM40COG471J GRM42-6 COG100J...

Can you help me? I need to pull a part number (GPN) based on the match from the other (SPN) part number in a table. My problem is the SPN is cut off and could match a grouping of an GPN. I need to Pull all GPNs based on the SPN. Ex below: SPN GPN GRM39-024X5R105K...

Thank you! It worked. Chris

Can you please help me? I'm trying to change my data in a field to delete anything after the "-". For example: XXXX-XXX to XXXX. I want to do this using a query. Can you tell me how to write this function? Thanks!

Did just that. Thanks

Hello, I am trying to calculate a net commission total in my report. I'm using a text box (different table) to pull in a total manual adustment total. I need to take the original commission total-Manual adjusted total= Net commission total. Can you tell me how to do this? Thanks

I figured it out. When I use >0 it works. I'm not understanding why it works with this symbol since the field is a "text" field Chris

I'm trying to make a table that only shows where our sales reps are spliting commissions with another rep. On table is all of the sales activity for the month, the other is the salesman number and name and other information. I'm linking the field "SLS" to one table to "REP" to the other table...

I'm trying to run a simple query to take out the the null values in my table. I'm putting "Is not null" in the criteria but when I run the query it brings back all the records. What's going on? I'm linking two tables. I don't see anything wrong with the properties. Please help. Thanks, Chris

Can you please help me? Each month I run reports for each of my reps which shows their commission values. I need to have the ability to go back and show a manual adjustment on the report. I use a large report that has all sales and a cover sheet. I looked at using a subform or table in the...

Yes, I know I tried both way's and no luck. Here is my calculation. rate: iif([value]=0, 0, [commission]/[value])

It's not working. It's telling me "you have entered an invalid identifier. it's highlighting at rate: if (

Now I have a simple calculation in a field to set the percentage rate of value and commission. Of course if the value is zero then I get an #Error in the rate field. When that happens can you tell me how to set the criteria to change the field to zero? Thanks, Chris

I have a pretty simple task to do but forgot how to make it work. I want a message box to appear like "STOP!!! Please fill in the status before moving on." before they move to the next field in the form. How is this done? I don't want them to be able to add info from the next field until they...