Search results for query: *

Is it possible to insert a report(as a sub-report) if it contains sub-reports? I currently have a profile page that has data displayed in a group header section and it also has 4 sub-reports. I have tried inserting the 4 sub-reports in various sections and everything I have tried works when I...

Is it possible to run a search on the crystal management console that looks at the sql commands for all scheduled reports? For example, if I have 500 scheduled reports on my server and let's pretend they all reference the same database table but the sql command is slightly different for all of...

I have a table that creates a new row of data each time an employees record is updated. In the example below, I have an employee that has been hired, terminated, rehired, reterminated, and rehired again. I would like for my query results to associate the employee terminate row with the...

I currently have 2 Access databases that are completely separate from one another. I have an ODBC set up for each database so I can run some Crystal Reports. My question is related to what fields are available to me when I make my ODBC connection through Crystal Reports. Database 1 - Only the...

WOW...It appears to work great. Thank you very much. I am very new to these types of queries and would have never come up with this. Thank you

I have a query which produces two columns called PKGID and ERPNO. The ERPNO field includes either a number or blank. The PKGID includes a number which can be duplicated numerous times. I have added a column called STATUS in which I have built an IF formula into that looks at the ERPNO column...

I have a query which produces two columns called PKGID and ERPNO. The ERPNO field includes either a number or blank. The PKGID includes a number which can be duplicated numerous times. I have added a column called STATUS in which I have built an IF formula into that looks at the ERPNO column...

I am looking for a way to filter a field (Batch Name) with duplicate entries based on criteria involving another field in my query. My database captures the time mail was received (in this case lets say 11:30) and a start time and an end time for various batches of documents being indexed...

I still get the data type mismatch in criteria expression error

This option states that I cannot have an aggregate function in the GROUP BY clause

I get a message that states that I did not include the specified expression Int(DateDiff("n",dbo_LogTable!TimeStarted,dbo_LogTable!TimeEnded)/60) & ":" & Format(DateDiff("n",dbo_LogTable!TimeStarted,dbo_LogTable!TimeEnded))as part of an aggregate function. Thank you again...I am also trying to...

Thank you everyone for your help but I am still stuck. Hopefully you all don't get sick of my stupidity. Here is what my SQL view looks like... SELECT dbo_LogTable.ScanDate, Int(DateDiff("n",dbo_LogTable!TimeStarted,dbo_LogTable!TimeEnded)/60) & ":" &...

I am having trouble with this solution. I am very new to access and I am trying to accomplish this exact same thing. I have a table that includes a start time and an end time. I have built a query that calculates the elapsed time. What / Where do I put this formula so I can sum up my daily...