Recent content by 94Sport5sp

Hi Brian: Yes, that would eliminate one of the nested If to generate the correct results.

Hi: I finally got it working. At least all my tests produce the results that I want. Brian: Yes that link does describe what I am trying to do, and my solution is very close to what that site posted. I ended up using an if statement with 2 imbedded if statements. I check if the end of the...

Both examples will work when applied to a single row of data. When different combinations are added then problems start to arise. I believe I need to add more sample to describe my problem. Assume inclusive report range starting May 2, 2015 and ending May 16, 2015. The question I would like...

Hi: I would like to do a test for values between 2 dates in Excel 2003. Since I did not find a between function I am looking for a different way to test this. Example if range of date is May 1, 2015 up to and including May 20, 2015 I would like to find any Start date which begins on or after...

Hi: The pivot table can only show rows if there is something to show. If you have a blank payment type in your data then it will show up as a blank row but if you have two blank payment types then only one row will show up. What are you trying to accomplish with blank data?

Hi: Glad that you got it to work. Thanks for the feed back. The cross tab feature of access is quite useful but can be a pain to understand. Something is different between the two fields and that is where the problem lies. The dummy table is not part of the problem but does show up the problem.

Hi: Creating reports (and forms even more so) based on cross tab queries can be challenging especially when the field names and field types can change. Your idea of using the dummy table to control the possible field names is good but needs some way of connecting it back to the cross tab query...

Hi: Column Headings provides as simplistic means of establishing column headings for crosstab queries and ensure a fixed number of columns are returned even when no data is present. Check out http://msdn.microsoft.com/en-us/library/office/aa191550%28v=office.11%29.aspx for some ideas. I will...

Hi: Can you share what the last query (the one the report is based on) looks like? Also are you familiar with the Column Headings property of the Query Properties?

Hi: Which version of access? I believe your problem lies with how a crosstab query returns results. When working with crosstab queries it is important to remember that the field names are the content of the values returned. This means than when you create a report or form based on a crosstab...

Hi JHB: Ha! Good question and now I know the answer to my question. The code I have is at the form level so it will not trigger until the user moves to a new record or closes the form. Thanks

Hi: I have a form which displays information in the footer until the use has accomplished some tasks. Once I verify that all is well I allow the user to change the fields in the footer. I want to verify that the proper changes were made but the BeforeUpdate event does not fire until the form is...

Hi: I came across this thread as I was trying to do something similar to the OP query and I encountered the same problem as the OP in that the number returned was always the same. In researching the problem I determined a couple of important item which need to be understood: 1st RND() is...

Hi Eljefegeneo: Glad I could help. Let us know how you make out or if you need more help.

Hi gemma-the-husky: Yes I had considered that option but I did not like the work involved. Currently the Client gets sales data from up to 14 sales areas but not all areas have sales. That would mean creating sales data for all sales areas which have sales (normal procedure) and then creating...