Search results for query: *

Good Afternoon, I have literally no experience with Python (lots of experience with Crystal and some ArcMap), but from what I understand, what I need to do is relatively easy. I suppose relatively easy is highly subjective. We have a map that has points and a density layer that represents...

Good morning, I have a table that has a column where street addresses are stored. Through a series of formulas, I display that address in a report in a specific format. For example, information such as the apartment number is excluded. The formulas work perfectly. But, I want to group the...

Hi, I have a report with two tables - packages (table 1) and statuses (table 2). There is a common column in both tables for linking - that is the package number. Each time there is a change in the package's status, an entry is made in Table 2. For example, V for verified, X for destroyed, S...

I have a series of transactions for inventory items that are stored in two different tables. An update is made each time the inventory item has a status change. The most current status (i.e., the most recent status change) is in Table1. When the status has changed, a new entry is made in...

Good evening, I have a report that selects data from two tables that are joined by a common field in both tables - the event number. Table 1 has one instance of each event number - Table 2 can have multiple instances of each event number. I need to be able to select records that were...

Good morning, I have developed a report that is comprised of a main report with only one field (event number) located in the page header along with some text boxes for the header. The report is grouped by event number but the group header and footer are suppressed. There is also a page footer...

Good morning, I'm attempting to summarize a formula field. I've browsed various threads on here regarding this topic, and the closest I can find to my scenario is thread 767-1098983. However, I'm having some difficulty. I am attmepting to summarize the duration of events that are calculated...

Good evening. I have a report that is grouped by file number. This is (presently) the only group in the report. However, I want to sort the groups based on a field (start time) that is placed in the Group Header (GH1). The start time field is a Formula Field. Is what I want to do even...

Hello, I have a series of transactions in a table. Each transaction is associated with a tracking number and has a date/time. There are multiple transactions for each tracking number. I have grouped the transactions by tracking number. I want to identify the first (minimum) transaction...

I would this what I am trying to do is fairly straightforward, yet the answer eludes me. I have a list of employees in one table, and a series of records they entered in another table. The common field between the two tables is Employee ID. I have linked the fields using a Left Outer Join. I...

I have developed a report that lists employees and summarizes some transactions for each employee. The report conists of two tables, the employees and the transactions. The tables are linked by the Employee ID and the transactions are all grouped by the employee ID. It's a long story, but the...

Good evening, I have a series of records that have a date and time stamp. I have grouped the records by two levels (reference number and employee ID). I need to identify the earliest record (minimum) and the latest record (maximum) and then calculate the time difference between the two. Does...

I am using the following forumla to convert seconds into time: NumberVar TotalSec := {VP_TIMESHEETITEM.TIMEINSECONDS}; NumberVar Hours := Truncate ( TotalSec / 3600); NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60); Totext ( Hours, '####') + ':'+ Totext ( Minutes,'00')...

In one of our applications, there is a field in which users can use an RTF editor to format lengthy comments/narratives. They have the option of using bold, italics, colors, etc. The field supports all standard RTF format functions. When I insert the field into a report, I want MOST of the...

Good evening, I've browsed the postings regarding comparing data in two tables and cannot find one that is applicable to my situation. I have two tables in two different SQL databases. Each table has a common field (reference number). I am trying to compare the two tables to determine which...

I have a field in which a person's height is stored in inches. Someone who is 6'2" has a value stored as 74". How can I convert the stored value to the more comment format of feet, inches?

Hi Everyone, I am working with an access control system. The system logs each time a staff member uses a card to access a door. The cards are stored in a Card table and the transactions are stored in the Transaction table. The Card has an internal ID for the table and an external ID for...

It's a long story, but because I need to use Bar Code Font 39, I need my date fields to have hyphens instead of slashes(04-01-2010 instead of 04/01/2010). The only options on the date format do not include hyphens. DOes anyone know how I can use hyphens instead of slashes? Thanks!

Good morning, I am attempting to retrieve records based upon a date/time field for the last full hour. Whether I run the report 1 minute or 59 minutes in the current hour, I want all records for the last full hour. Also, I am attempting to retrieve records based upon the same date/time field...

I have a report where I have included the 'Record Number' special field in the Details section of the report. The recipient has asked that the record number be reset at the start of each page. Does anyone know how to accomplish this?