Recent content by ekr

Thanks to everyone for the suggestions and tips! Cheers- E. Rice

Got it. What if I have a new piece of data that I would like to associate with my item numbers, such as an ID number for a materials list. E.g. Item 12345's materials list ID number is 678A. Can I use an update query for that? Thanks! E. Rice

Hi Skip - Thanks for your reply. Yes that is correct-I would like to keep the existing price field for comparison and I have some linked reports.

Hello- I have a spread sheet of new prices for 1000+ products. I would like to load these prices into my Access database as a new field (newprice). How do I tell Access to take item number 12345 from the spreadsheet and add "$XXX" to the newprice field? I assume this is an update or append...

thank you so much for the assistance! works perfectly

Hello- I am trying to group data points to get a subtotal. I have item numbers with 'suffixes' whose quantities I want included in a subtotal, but not grouped separately by item. For example, item qty 8471 3 8471-1B 8 8471W 4 all should be in group "8471" and show a...

Hello- I am trying to create a Crystal Report, extracting 'Project' info from the OpMgr table. I have selected RecType=P for Projects, but they are still not appearing in the report. Goldmine 5.5 and Crystal 8.5 (yes I know I have dinosaurs here.) Any ideas on how to set up a Project report...

Thank you x 1,000,000! This works perfectly and I would never have been able to figure it out without the help. I sincerely appreciate your taking the time to share your knowledge. E. Rice

string.

Thanks for the help. I am getting some error messages that I can't seem to blast through: "A number or currency amount is required here." (in front of {details.List Price} ) OR "The remaining text does not appear to be part of the formula." If I put a number there, it multiplies it x 10 vs...

Hello- My dataset has 500 items, each with a unique price. Each of these items is associated with a category. Based on the category, I want my report to calculate a new price. For example, if the category is A, multiply the price column by 10. If the category is B, multiply price column by...