Recent content by MrBillSC

I have just converted an Access 2000 database to Access 2010. The reports all had the current date printed in the page footer (=Date()). The 2010 version prompts me for "Date" and then prints "#Name?" in its place. If I delete the date field from the page footer and try to insert "Date and...

I am new to writing xml code. I am linking two tables and I want to select the first table records whether or not there are linked records in the second table. When I enter the following code the report give me errors: <table type="left_outer_join"> <table type="table"...

Hi All, I am using xml code to retrieve records from a database and will display them in a report. I only want to select records where the 5th character in "VP_Permits.TypeCode" = "G". I can't seem to figure this one out. Can anyone help? Thanks, mrBill

I think I found the answer from searching through other similar questions. Hope I didn't waste anyones time. mrbill

Some of our Access databases (Access 2000) seem to automatically generate copies of themselves. What causes this to happen? Not all of them do this. Thank you, mrbill

Have you tried using the DistinctCount summary function? MrBill

Try the following: Group on {table.empl_num}, {table.case_num} Open the select expert and click on "Show Formula". Click on "Group Selection". Click on "Formula Editor". In formula editor enter: DistinctCount({table.case_num},{table.empl_num} >= 2 Save and exit. This should suppress...

If you want to capture the last record of the second group try "Use a formula" in the evaluate section: // Check for Type changing from Null to a value. (IsNull({Table.Type}) and Next({Table.Type}) > "") or // Check for Type changing values. {Table.Type} <> Next({Table.Type}) or // Check...

Have a programmer open the report. On your menu bar click File > Print Setup. Check the No Printer box and Click OK. Save the report. MrBill

To calculate age as of Jan 31, try the following: // formula Age: If Month({table.BIRTH_DATE}) > 1 then DateDiff("yyyy",{table.BIRTH_DATE},Today) else DateDiff("yyyy",{table.BIRTH_DATE},Today) + 1 MrBill

Try: If Month({Delivery.Promised_Date}) = Month(Today) and Year({Delivery.Promised_Date}) = Year(Today) then {Delivery.Promised_Quantity}*{Job.Unit_Price} MrBill

If you don't want a new column for each group you could try the following: 1. Insert a section below your group header and expand to the same size as your detail section. 2. Copy and past detail section field into your new group header section "b" so it looks identical to the detail section...

Assuming you are grouping on Item_Num, place the item_num field in detail section. In group footer place a formula: Maximum({table.last_recvc},{table.item_num)

Create a formula called LegalEntity01 //formual LegalEntity01 If {table.PCap} = 1.00 then {table.LegalEntity} else " " Place the formula LegalEntity01 in your detail section. You will probably want to suppress printing it. Right click on the formula and select Insert > Summary. Select...

If you only want to display the date part of the date/time field you can simply change the format by placing the field on your report and right clicking. Select "format field". Then select a format that only displays the date. MrBill