Search results

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...

Hello, Does anyone know what PKG9.mdb is? The reason I'm asking is because I'm trying to Link a Database through Lotus Notes. It gives me an Error telling me it cannot find PKG9.mdb on my C Drive. Funny thing is I'm trying to link a database which is called Menareports on P Drive. Do you have...

:confused: When I try to Transfer a file in txt format to another directory I get the message;"Cannot Update. Database or object is read only. I never had this problem until I converted Access97 Database to Access 2000. Can you help?

I'm trying to convert a access 2000 database back to Access97 for other users to use the reports. I can convert the tables and queries back to 97 but the reports do not. Is there a way around this problem? It looks like, once again Microsoft did not look at every scenerio before releasing the...

I'm trying to add another total to my report. Right now I show Monthly Sales By Region. I want to add another grouping above the regions. I want my report to look like this: Japan East Region Totals Japan West Region Totals Japan Region Totals (includes Japan East and Japan West Regions)

Please help!!!! I'm trying to either preview or print a report in Access 97, however everytime I do an Apllication Error comes up. This problem came up after I upgraded from Windows NT to Windows 2000.I've tried to update the printer drivers already. The Error Reads: The instruction at...