Search results for query: *

tks for your help. The data set is a rolling year and I am reporting on each month separately. One more quesiton If I may, Where do you declare the variable ? K

I have to run a series of audit reports each month. For each month I count the number of audits(audit #) number of failed audits(yes/no ) and then do a calculation to find the failed percentage. Essentially 3 formulas. Right now I have a start time and end time that I have to replicate in all...

its that easy :) I will give it a shot...

Hello Folks, I am trying to create a daily report that will capture inforamtion from a SQL database. The only problem I can;t seem to resolve is a formula to extract ony informations based on yesterdays date, sord of. The report will be ran once per day. It will be ran through Crytal Reports...

sorry...I thought I hit preview post the first time ...:)

I will give it a shot...I have the formula by Audit Number but never inserted the else null...

your suggestion worked Pam, thanks so much. The only issue I am having is the folowing: I am reporting on totals quarterly as well as the rolling year total. Strange as it may seem, everything works great but the total for the year is exactly +1? ' Example: Black Jack 15 for th5 first...

Hello, I have a command object created to extract the following fields: AreaAudited: (ex Slots, Table Games) Section: (ex BlackJack, Live Payments) GameAuditStartDateTime: (date time field) ReviewMethod: (Pass, Fail, Live) Number: (Audit number ex GA20120002122) Violation: ( I want to create...

Hello, I have a command object created to extract the following fields: AreaAudited: (ex Slots, Table Games) Section: (ex BlackJack, Live Payments) GameAuditStartDateTime: (date time field) ReviewMethod: (Pass, Fail, Live) Number: (Audit number ex GA20120002122) Violation: (incorrect payment)...

thanks for the assistance. I tried these formula's out on a crosstab and they worked great. Here is my setup: I have two tables: Game Audit Table Fields: GameAuditGUID (primary key) GameAuditStartDateTime(date field) Area (ie Table Games, Slots etc) Section (ie blackjack, roulette etc)...

thanks for your reply Ian. I created two formula's and was able to draw the inforamtion for Quarter 1. When I created a similar formula (different min and max date values) to extract information for Quarter 2 I get the same summary information for quarter 2? I am inserting a summary field...

Hi THere, I am creating a manual crosstab and would like to count the number of records that occur between two sets of dates. I am using the following formula if month({gameauditstartdate}) in [1] then ({gameauditstartdate}) else 0 I would like to be able to select the more than just the...

thank-you very much for your help. I am able to get everything reporting correctly. It may have been th 3equoted as well as teh MOnthname instead of month. Thanks again, C

Hello, I am creating a crosstab report that will show values based on month of the year. I want to use a formula in a column that will capture the inforamtion based on each month. I want to view the inforamtion by year(2005 - 2007) for each row. I thought of using this formula but I keep...

The formula is working great. Thanks so much for your help. C

I think this may help. I am reporting on an Access Database that uses the following fields in one table: 1. EntryID 2. Date 3. Over 4. Short 5. Remarks I would like to report the number(count)of discrepancies that fall into the following categories. 0-10.00 10.00 - 20.00 20.00 to 30.00...

The trouble is I don't know where to start. I was thinking an "If Then" Statment would work but I am unsure of how to apply a value if the stament is true? If the value is boolean how can you count it afterwords?

Hello, I do have a date field for the columns. The discrepancy total is made up of two fields. One is called "Over" and one is called "Short." I was hoping to calculate the value and then use it to count the number of dicrepancies for each month in the report. Thanks again, C

Hello, I am preparing a bank discrepancy report that will group the discrancy amounts into groups based on 10.00 dollar increments. It would start at 0 - 10.00 and work its was up to 90.00 - 100.00. I would like to project it over a calendar year and hoped to use a crosstab with the dates(by...