Search results for query: *

I finally (after almost a week of struggling) worked it out for myself! I did switch from Crystal to Basic syntax to make it easier. I am sharing in hopes that others might find this useful. My report output looks like this (it does line up right in the report): Jan-08 Feb-08 Mar-08...

LB- My database has dates in text format - 20080101 for example. I use this function to convert to date: Function (stringvar JoltsDate) If not IsDate(Mid(JoltsDate,5,2)&"/"&Right(JoltsDate,2)&"/"&Left(JoltsDate,4)) then Date(0,0,0) else...

Hi, We are running CR Ver 10.0.0.053 on Windows XP. I have been struggling with this code for a week now and can't seem to get it right. My records have a detention start and a detenion end date. Given a parameter report start and end date, I am trying to use arrays to generate an average...

LB, I was hoping you would pick this up. You are brilliant and of course this works perfectly. So obvious now that I see it, I can't believe I couldn't figure it out on my own. This applies to about 40 of my reports and the users had asked me to make separate versions - so this is particularly...

Hi, I routinely create reports with a multi-page detail section with lots of records and then a multi-page summary section with lots of crosstabs(report footer). Users want to be able to print the full report or just the summary but to have page numbers based on what they want to print- ie...

LB and Ido, I appreciate the suggestions about a table but that is not a practical solution for our system. The table would have to be in a separate database and maintained. Our goal is automation and user independence. S

The following illustrates what I attempted, the results and what I was trying to get instead: Parameters: ?startdate = 1/1/2006 ?enddate = 3/1/2006 Formula Field: Days (I placed this in details section) numbervar x:=1; datevar thisdate := {?startdate}; datevar enddate := {?enddate}; while...

For example 7/1/2005 through today (3/2/2005) S

Since the user can specify any period, that would be very difficult. Sandi

A POD is a section of rooms/cells. Yes, I do need to show a count for every day within the parameter period. That is what makes this so difficult. Sandi

Appreciate the suggestion, but don't have a table with a record/date for each date the juvenile is in detention; just a start and end date, so I don't beleive this will work. Sandi

Hi, I have scoured the forum and tried several things I found but have not been able to acheive what I need to do. We are using CR Profession Ver 10.0. The database is an AS400 database and I am linking via ODBC. I have a table with JuvNo, DetStartDt, DetEndDt, PODNo (not actual fieldnames...

The following code works fine when the pivot table data is in a worksheet in an Excel workbook: ActiveSheet.PivotTables("PivotTable1").PivotFields("PRODUCT LINE").PivotItems.Select With ActiveSheet.PivotTables("PivotTable1").PivotFields ("PRODUCT...

I have a Time Tracking Time Entry form used for data entry. That form has a subform which shows all the time entries for that employee for that day. When the form loads, everything looks great. As soon as I try to navigate the subform (using record navigation or scroll bars) ALL the rows of...

Yes- I do have vertical scroll enabled. When I click on the subform, my Employee Name field goes blank which I'm sure is why the subform data is disappearing, but I can't figure out why the Employee Name field should change at all (I tried locking it and that did not work either). This si my...

I have a Time Tracking Time Entry form used for data entry. That form has a subform which shows all the time entries for that employee for that day. When the form loads, everything looks great. As soon as I try to navigate the subform (using record navigation or scroll bars) ALL the rows of...

Thanks David- that worked and did autopopulate the network user ID. Now how do I get it to actually fill in the Employee's name? Sandi

Hi, I am desperate for help! I am developing a time-tracking database with a time-entry form which will be used by each person in our dept. I have a query that uses a function and identifies the network user ID of the person logged on and their name. I would like the employee name to...

Could I get your sample mdb too? I am trying to solve the same problem. Would be much appreciated. I am using Access 2000 and my email is sandra.burgess@mahkc.com. Thanks!