Search results for query: *

Hello Again! In thinking more about your comments regarding NUll values, I was able to resolve my problem. Basically, I changed my query where if hours is > 39.5, I return NULL. Since the Count function in the report only counts NON-NULL values, it counts all hours less than 39.5 correctly...

HEllO!!! Thanks again for your reply. I tried the expression, but it does not work. I receive the error Data Type Mismatch in expression. To clarify, I am using "". In my Query, my immediate If Function returns "", if the hours are > than 39.5. Otherwise, it returns the hours. I simply...

Hello! Thanks for your prompt response! Here's the SQL code for my Query. Again, I am trying to create a calculated control in MS Access Report to Count the records without "". Let me know your thoughts..... SELECT DISTINCT dbo_Store.region AS [Zone], dbo_Store.district, pay2.STORE_NUM...

Hello! Query: Fields ID # 12345 03/06/04: IIF ([3/6/04]>39.5," ",[3/6/04]) 03/08/04: Same as above Report: Tied to Query Above. Trying to count all 3/6/04, 3/8/04 records that do not contain " ". Is this possible? I've tried the following formula in my report: Count([3/6/04]). The...

Thanks JonFer! The CDBL function worked. My results are now sorting correctly to the 10th decimal place. Thanks Again!!! =)

Hello Everyone, Thank you All for your continued advice. Here's my response.... TonyJollans: Q: What happens after the Query to produce output? A: The calculation is numeric. Used the Format Property to Format the result as a %. Just to clarify not all of the output of the query is in...

Hello Bob, Here's my SQL CODE... SELECT dbo_store.region, dbo_store.district, dbo_store.store, dbo_store.store_name AS [Store Name], [Sales Plan % & Sits Plan %].SumOfdsittingsty, [Sales Plan % & Sits Plan %].[% Sales Plan], [Sales Plan % & Sits Plan %].[% Sit Pl], [% Plan Hours].[% Plan...

Thank You for your Quick Response. I am positive that I have not sorted by store. How come my query doesn't sort to the nearest decimal place? I had also show my query to a DBA and he is also stumped. PLEASE ADVISE & THANK YOU!

Hello! Query: Only Store # & % Plan Hours fields. Sorted % Plan Hours in Descending Order, but it did not sort the records to tenth decimal place correctly. For example, Access returned the records in descending order as such. Store# %Plan Hours 2...

Thanks Bob! I'm a Non-Programmer. Not quite sure how to execute your suggestion. Can you please advise on how I can create the label in a non event procedure? Or break it down step by step. Thank you once again!!!

Hello! Created a Report that is summing by Quarter. Question is how do you reflect Quarter 1 or Quarter 2 as a label. I can create a text box with Quarter, but would like it to state it's related Quarter... (i.e. 1, 2, 3, 4). How do you do this? Any help would be appreciated. Thanks!

Thanks it worked perfectly! YL

Thanks for responding so quickly! I actually need to RANK sales figures by assigning a RANK to the store with the highest sales figure. For Example, assign a 1 to a store w/$100k in sales, 2 to a store w/$99k, and etc... for a certain period of time (Quarter One, etc...). Can anyone help? Thanks!

I need to Rank Sales Figures for a specified Period? Is their a function in ACCESS or an SQL statment that does this? Thanks!

Thanks for your response! It doesn't return the figures correctly - Triples/ Quadruples the sales data. Do you have any other suggestions? Basically, I need to create a Report based on this Query. The user enters the Date Range and a report generates based on this Date Range. The same Date...

Create a Query where the parameter applies to two differnt tables with the same Field Name. For example, Table 1 Store Sales Date Table 2 Store Sales Plan Date I would like to create a subtotal query based on the two tables above. I would like the Parameter Between [Start date] And [End...