Recent content by dvraggs

Hello everyone I have a decode question. My table: item date id dog 01/01/2004 24 cat 02/04/2003 24 dog 04/08/2004 26 cat 06/04/2003 26 i want it to look like this: id dog cat 24...

I will be programming with vba in another tool that calls outlook and emails me when done. it works great, but my emails address is hard coded. What I want to due now is pull the report creator name out of the report( did it ) and email them as well. My question is the name of the report creator...

I am looking at use ones joins and see that the person has two joins between two tables. One of the joins is a many to many, and the other one is a one to many. Can you get good results doing that. This is the first time I have seen this type of joining.

Thanks for the reply I have usred another method

the question is how to query single row with each item side by side like order#,item,item,item,amount

hello, I have a table I take order. that table uses item key to look up item on other table. One order might appear twice because two items. this work great for everything i do, but look at orders with same items and different order amounts. I though about decode but there are over 100 itmes...

Worked Thank you

I need and inputmask to be 999-A-9999. The 9 can be any number and the A is Alpha. Can anyone help.

VBA coding did the trick.

thanks what I do with that is keep up to date list of what I have printed Order IDs.

I Have a report built that I run monthly I have the report write out to and execl file the order numders. I want to use a copy of the file as list of numbers not to pull. I tried importing the file as a datasource but can't get it to be a Charter field to match the other one. Is their a way to...

I was thinking I could use this to append to a list that I keep. anyone have example of its use. Thanks

I'm new to databases, I wanted to known if there is away to create a store proc. that will look at a list table and compare the Order_IDs on this table with new query like this 'give me all order_ids that are not in this table' then fill another table with the results then update the list table...

I have a report that uses two dataproviders one for data the other is excel file. my do not equal to excel file to keep track of things I have pulled. Right now I add to excel file mannually what was in the report that I just pulled. Is there a way to append the data in report to excel file with...

anyone use the method changeuniverse. I can't get it to work.