Recent content by dwood@atx

So this does work for me but I'm curious if you know of a way to make it display a week even when it has a $ 0 result. I have 3 different regions that I will run this query for and I need to put them side by side in a report. currently when I run the report if one of the regions has a $0...

I think this should work! Thanks so much for the advice. I will post again if it works out! THANKS!!! :)

sorry I should have been more clear in typing. It would not always be a Monday to Friday when the week is at the beginning or end of a month. If the 1st fell on Tuesday then the week would be Tuesday to Friday. If the month ended on a Friday for example the last week would only contain...

Sorry I'm not very good at putting my thoughts down in writing. So the first day of a month would be the first day of week 1. For November week 1 = Tuesday November 1st - Friday November 4th The last day for November would be Wednesday November 30th I am looking for achieve...

Thanks for your reply! The weeks would always end on a Friday (Business week from Monday to Friday). so the dates need to change depending on the month Thanks!

Hello Everyone, I'm looking for help with a formula. I know how to get the week end and start date for a current week but I am looking for the start and end dates for all weeks in a current month. For example in this month October 2016 I need week ending totals for October 7, 14, 21...

THANK YOU!!!! I have been looking for this for so long!!!!! So dumb :banghead:that I didn't look at the Bound Column as the issue! because Yes the date for each months currency is the same...the first one on the list is always selected! YAY! thank you!!!!!

here is the SQL SELECT CurrentExchangeQry.ID, CurrentExchangeQry.CurrencyType, CurrentExchangeQry.CurrencyDate, CurrentExchangeQry.CurrencyRate FROM CurrentExchangeQry ORDER BY CurrentExchangeQry.CurrencyType; Bound column 3 column widths 0";1";1";1" control source Currency (One of my...

Yes the first row of Data. Sorry I was not clear.

I have a combo box based on a query. The query selects the current months currency exchange rates. the combo box allows the user to select the type of currency and then one of the columns in the combo box is used to multiply a foreign amount into US dollars. The problem I am having is that...

Thanks so much this is a great idea. It actually turned out that my problem was in my data import from excel. I assumed my issue was the formula I was using in my query but when I went back to the table I saw my numbers were off. I re imported my data and its all good now. Denise

Hello everyone, I have a query that pulls current year, month, and Quarter to date totals. I would like to compare each to the same time frame from the previous year. So if today is August 16, I want a comparative for everything up to August 16th last year. The formula I came up with works...