Search results for query: *

Cr10Dev Sql Server 08 I need to create a formula that displays daily attendance, attendance is taken for each class period. I only need to show they were absent if they missed 5 or more periods per day, then have a running total of their absences. Not sure where to start. Currently my...

Cr10 Dev SQL Server 2005 I have a report that sometimes will go to 5 pages and I need to have page six blank for duplex printing. This problem is when I have page N of M in the page footer. I have tried Remainder(PageNumber,2) <> 0 but still having issues. My sections are: PH 2a - 2b GH1a -...

CR10 Dev SQL Server 2005 I have a shared variable that I pass from the main report to a sub report. I have placed the formula in the main report group header 1a. Everything passes to my subreport fine which is in group header 1d, the trick I am having is I can not insert a max summary in my...

Cr10 Dev SQL 2005 I have a parameter where a user may select multiple values. My issue is when I try to display all the values on the report I am only getting the first one that was selected. The options I have selected are Allow multiple values and Discrete Value(s). Not sure why when 1 or...

I am wondering if anyone knows of a way to take a 32bit argb color and convert that into an RGB() color? Cr 10 Dev Sql Server 2005 Express Thanks, Gj

I have a query I wrote in Oracle but I can not seem to get it to work in MS SQL 2005. I need to get the name of the author with the most orders. The query below gives me the name and the max count, but I only want to see the name. That is where I am hung up. (Select fname, Max(TotalB) as...

Cr10 Dev MS SQL 2005 I have an object that is set to grow, what I am wondering is if that object does grow can I tell another object to grow the same height? I am not sure if this is possible I have looked around and have not found anything so I thought I would check here. Thanks, GJ

I have ~ 300 records where I have the UNC path to files that relate to my records. What I am trying is to follow the path and retrieve and insert the datemodifiedlast into the same table as my records. Not sure on where to start. I know how to write the code to select my field, just unsure on...

I have 2 formulas that I am multiplying, 1st formula is 6 digits, and 2nd formula is 14 digits. My result shows up as 9.61e+019. I need the result to be the whole number. Any ideas. Thanks, Glenn

I have a query where I only want the previous weeks data. I have it working in Access but I can not get this to work in Excel. Using Office 2k, querying DB2 database. Any suggestions? Thanks, Gj ((Format([SHARE]![CLOSE_DATE],"wwyy"))=Format(DateAdd('ww',-1,Date()),"wwyy")))

I am creating a merge document that looks at many fields from my source. I have 2 fields that hold balances, what I am trying to do is check the value of Bal2, and then only show 1 field depending on the value. I have not wrote vba for word before, so not sure how to do this. Thanks, GJ...

I receive a compile error when my code gets to frmCalendar.Value = Date. It highlights date and gives me the error. When I click ok then my references window opens. Does anyone maybe have an idea of a reference I am missing. I have tried adding several, but no luck yet. If I remove that piece...

Is it possible to install Access 2003 onto a machine that currently has Office 2k without overwriting the 2k applications. Thanks, -GJ

Does anyone know how to export the field names along with records from a table. I can export all of my records but would like the field names as well. Thanks, GJ

Need some assistance with my code below. All I am trying to do is export data from a table into excel. I receive a type mismatch error that I can't figure out on this line of code. Any ideas? Thanks, GJ Set rs = db.OpenRecordset(strSh, dbOpenSnapshot) Function Export() Dim xlobj As...

Is it possible to for a user to select criteria from a form and have a cmd button to run query based on the criteria they selected. I have my query built, just not sure how to do the other. Thanks, GJ

I have very little experience in Java, so I was wondering if someone might be able to help me write a function that will place an x in place of the first 5 digits of a SSN and then show the remaining 4 digits. The SSN will come from a field named TIN. Hope this makes sense. Thanks, -Glenn

I have around 200 rows of data with 2 empty rows separating each group. I would like to insert a specific value into the upper most row for each group in column 'B'. Here is my code I am trying to get to work. As of now it is giving me 2 values for each group. Hope this makes since. Private Sub...

I have a range of numbers that have a score and date for each number. I have grouped by number, and I am now wanting to get the most recent date and score for that number. I have tried Maximum(Date), but run into problems, so I started looking at using the Previous() function. Not sure how I...

I have a field that has numbers that I would like to remove the last 4 digits from. This is what I have tried, but get a column of #error for each record. Place: Left([PrimaryAccountHH],InStr([PrimaryAccountHH],",")-4) Thanks, gj0519