Search results for query: *

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.

I Wrote some vba code to do everything , but the porblem is it exports into 60 excel files I want one excel file with 60 tabs. Can any one help me. code.. Private Sub Document_AfterRefresh() Dim dopDoc As Document Dim mydopRptAs Report Dim FilterVar As DocumentVariable Dim FilterChoices As...

I would like to get a report tab for each one with a dulicate report. I got code to loop thru and make a duplicate or createquickreport to make a tab for each. So how I need to do both. CreateQuickReport has no format. The goal is to have a report tab with a formatted report with the master and...

I have a problem. I have a report that has a column with codes(010). I need to apply a filter and make a report for each code. So what I will a report called 010, 020, 030 ect. Is there a way to do this without doing it manually.

The database was not a date it was a string. I hade to use ToDate first then DayName. Thank you, Dvraggs

I figured it out.