Search results for query: *

Thank you so much... I knew it was something I've done before, but just had a brain lapse. It was driving me crazy! Josh

Hello, I currently have an Access db with a query consisting of the following data: DTE STORE_ID FREIGHT TAX_DUE SVC_USED 6/2/14 1 0.00 284.72 -13.26 6/2/14 2 20.00 579.27 -40.00 6/2/14 3 26.90 11.74 0.00...

I'm sorry LB, but I'm confused aren't you using the parameter fiscalyear in your summary formula? //{@This FY}: if year({table.date}+<somenumber>) = {?fiscalyear} then {table.amt} I think I have some serious flaws in my report. This is my record selection criteria: {TB_RECEIPT.DATE_CLOSED}...

Thank you again for your time and response. I apologize for the confusion, but I am not referring to the fiscal year I am using our fiscal calendar. Not only do I have to take into account what the Monday of last year was I also have to make sure that it falls into the same week in my...

LB, I actually have a formula that will take into account our fiscal calendar depending on what the user enters as the beginning date for the parameter. Right now where I am using the dateadd("yyyy",-1,minimum({?MyDateRange})) to dateadd("yyyy",-1,maximum({?MyDateRange})) I will just insert...

Hi, Thanks for the quick response! The problem is that I need this by each day for a week comparing Monday of this year to the same Monday of last year, Tuesday of this year to the same Tuesday of last year, etc. If I was able to just return 2009 compared to 2008 then I could use your...

CR 2008 w/ SQL Database Hello, I would like to thank anyone who takes the time to help me out with a report I'm building. I have just recently got back into Crystal reports after 5 years. I am trying to build a report that will show sales for this year compared to last year along with %...

I would like to thank everyone who took the time to help with this issue. To see how I was able to get the solution I was looking for with the help of Tek-Tips please reference this thread: http://www.tek-tips.com/viewthread.cfm?qid=1443457&page=1 Thank you again! Josh

MajP, Thank you very much for that portion of code. I had to make a few changes since my table structure and issue wasnt quite as simple as my example, but by using your code as a foundation I was able to achieve my goal. Once again I had a great experience in this helpful community and...

Thank you everyone for your replies. Sorry I did not respond sooner, but I have been swamped all weekend and this morning. I will look over everyone's suggestions and update you all on my progress. I am under the impression that this is how the flat file needs to be formatted in order for...

Hi Everyone, I posted this a few weeks ago in the Access Queries and Jet SQL Forum, but I feel that it may be better suited here. Unfortunately, due to multiple obligations with this data conversion, I had to take some time off from this part of the data. It has since become a priority again...

Remou, I think I'm following you here. My problem is that while I loop through the table I can't get the multiple barcodes in separate columns for the same style. You are suggesting that I append to the same column and separate the barcodes with a comma. Instead of having 9 columns per row I...

Thanks for the reply Remou. I did look into crosstab queries with no luck. I thought that since I'm really not totaling anything that was the reason for the strange data resulting from the crosstab query.

Hi Everyone, I am currently dealing with a table in Microsoft Access 2003 . This is for a data conversion where my current database has a repeating Style for every barcode associated with it. The new system's table structure wants one row for each Style and the barcodes filter through...

Thank you everyone for your quick responses!!! --Chris I appreciate all the great advice. As for the code, the site was done in Dreamweaver. I guess I could go back through and clean up some of the changes you mentioned, I need to brush up on my html first.... it's been a while. The...

Hello Everyone, I was hoping to get some input on a website that I developed for the new owners of an inn that I used to help manage. I was on an extremely short deadline and an even smaller budget so there are a lot of things that I did not get to do with the design and layout...

Gavin, Oh I definitely won't forget to give Skip a star he's helped me out tremendously. Thanks for the suggestions, I'm going to give that a shot. Josh

I did the same thing you did, pasted that sample data into another spreadsheet and ran the code with the correct results. So I was trying to figure out why there would be a difference and I found that if I copied that sample data multiple times on the spreadsheet with empty cells between each...

Hi Skip, Here is a small example of the data that we are looking at. This example is from a Mail Delivery Error Message: Organization: Company Name X-Mailer: YAMS 3.4 To: "customer@prodigy.net"<customer@prodigy.net> Subject: Company’s Monthly E-mail Sender: johndoe@company.com Mime-Version...

Hi Skip, Sorry, but reporting preparation for inventory takes precedence over all other projects. I finally got a chance to take a look at the code you provided for me. It seems that when I run it I am not getting any output. I was hoping you could explain the code a little bit for me so...