Search results for query: *

Hello all, I want to export my fields, types and descriptions from Access to Excel. I do not want to export the data itself, just the fields, types and description of fields.

I am using Access 2007 and I am trying to develop a small application for tax purposes. What I need to know is what is the best approach to exporting or converting the data in Access into a text file to be sent to recipient in the correct format. Here is what I have now...but this is hardcoded...

Hello all, I am needing some kind of direction on how to create output and input forms in Access. I know nothing about Visual Basic, however, I am needing to create Tables and Forms to store the data into Access. My question is this...if I just import the external data from Visual Basic into...

I have a gentlemen that has built data and codings in VB and I want to store the data in Access...what do I do next? I know how to build tables in Access, however, I do not know what I need to do to store this data in Access. Help me wrap my brain around the concept. Any help will be...

Hello all, I am using Crystal Report XI. I need a simple formula that will allow me to do a range on a list of last names. For example, I would like to see all last names that starts with range of A-L...this is what I have now: {DefLastName} startswith...

I am using Crystal Report 8.5 and I want to calculate how much revenue collected in a particular year. I am having a hard time thinking this through... Say that I had 176,000 cases filed in year 2003, and 55,000 of the cases filed were closed in 2003 due to payment. I want to know the revenue...

Can someone interpret this formula? NumberVar DoBVar := IIF((100 * MONTH(CURRENTDATE) + DAY(CURRENTDATE)) < (100 * MONTH({Case_party_PHYSICAL_TABLE.CP_DOB}) + DAY({Case_party_PHYSICAL_TABLE.CP_DOB})), 1, 0); NumberVar YrsVar := DATEDIFF("yyyy",{Case_party_PHYSICAL_TABLE.CP_DOB},CURRENTDATE) -...

Hello All, I am using CR 8.5 I may have asked this question before, however, I cannot find a thread to answer this question for me. I want to create a list of cases that are set on a particular docket and identify those cases that may need a complaint form. If complaint form is already on...

Hello All, I am using CR 8.5. I have the following setup: CNumber: 1234 Action: Letter Action: Complaint Form CNumber: 4567 Action: Letter CNumber: 7890 Action: Letter Action: Complaint Form I want the report to display cases that have both the 'Letter' and 'Complaint Form' on...

Hello, I am using CR 8.5 and I need some help with retrieving data from two different tables. I have a report that look something like this: {table1} {table2} CaseNo DocID ActionDocID 123 W1 W1 456 W2 W2 789 W2 W2 321 W1...

Hi, I am using CR 8.5 and I want to be able to count data from one table that may not be in another. I have two tables linked, one named 'table.WarList'(primary table) and the other named 'table.ActionList' and they are linked by it's common field the case number. I have chosen the option to...

I am using CR 8.5 and I need some help on conditional running totals. Here is my setup: TransAmt PaymentType 200.00 JC 600.00 CA 300.00 CV 400.00 JC RT 900.00 Basically, I do not want to count amounts that have a payment type of 'JC'. Please...

Hello all! I am using Crystal Report 8.5. I am having a problem retrieving the data I need. Here is my setup: My report is grouped by Case Number Running Total Summarize {table.Transaction} Type of Summary (sum) Evaluate On change of field {table.ReceiptNum} Reset On change of group...

Hello, I am new at this, so bare with me. I am trying to retrieve data from my Microsoft Query set up. I have the following SQL statement: SELECT Case_party_PHYSICAL_TABLE.JEboA, Case_party_PHYSICAL_TABLE.PARTY_TYPE_CODE, Case_party_PHYSICAL_TABLE.CP_NAME_LAST_BUSINESS...

I am using Crystal 8.5 and the report is grouped by case number. I have created a formula field named 'Action'and in the formula editor I have: if {Action} in "ActionName" then 1 else 0 Then I have place the formula into the Group Selection Formula Editor as follows: sum ({@Action},{Case...

I am using Crystal 8.5 and I have data that duplicates the case number periodically. See as follows: 123 456 789 789 789 I want to color or highlight the cases that are duplicated in my data. Please advise. k

Hello, I am using Crystal 8.5 and I am needing some help with a formula. Here is how my data looks: Grouped by License # and then by Name ______________________________________ Doe, Jane License #555KL5 Duck, Donald License #555KL5 _______________________________________ I...

Crystal 8.5 I want to calculate a grand total for all groups after evaluating on change of field. I am grouping by case number. Example: Group 1 50.00 50.00 75.00 75.00 = 125.00 Group 2 10.00 10.00 20.00 20.00 = 30.00 How do I display the 155.00 value instead of the duplicate totals within...

I am using Crystal 8.5 Here is my setup: RecordNumber TransDate TransAmount 1234 10.07.07 25.00 5678 10.14.07 5.00 Total transaction amount is $30.00, however, the problem I run into is duplicate line item when...

I am using Crystal Reports 8.5 version. I am working with two tables: 'Action Case Number' and 'Case Notes'. In the visual linking expert, the link is as follows: Action Case Number->Case Notes The linking option is "left outer join".(there is no reference in the record selection formula...