Search results

Hi. I'd like to be able to say that today is so many years, months & days since a specified date. Better yet, would be to include hours and minutes, or hours to 2 dps. At present I can only count days, using: =Date()-#13/02/99#+1 & " days" I know I can use the DateDiff function as an...

Hi. I have a report that contains duplicated fields. Also in the group header is a hidden field: Name:AAA Control Source: =1 I was told by a list member (Rich) that if I sum the 1s from the group header in the report footer it would give me an accurate count of all distinct records (and not...

Hi. I recently asked for help with a problem regarding counting only non-duplicated records on a report, and a member called Rich gave me a solution, but I'm still lost. My database is basically monitoring damage to vehicles. Each vehicle has a unique Chassis Number, and some of these have...

I have a report with a grouped header (damage type) and a sum in the group footer, with a grand total on the last page. This basically gives subtotals on each page and a grand total on the final page. At present the last sub-title (group header) appears on the second last page (which it should...

Hi. I have a data entry form that contains price boxes. There is a total box, which simply adds these prices together with the control source =Sum([Price 1] + [Price 2] + [Price 3]) This works fine. However, when I go into design view and save changes, the total stops working and displays...

Hi. I am in desparate need of help a.s.a.p. I'm currently programming a database at work and have come across one of those frustrating Access stumbling blocks. My database is basically monitoring damage to vehicles. Each vehicle has a unique Chassis Number, and some of these have multiple...

I realise this has been answered, but I didn't undrestand the answer! I NEED TO HAVE A TEXT BOX AUTOMATICALLY INSERT TEXT WHEN I ENTER A CODE FROM AN ADJACENT COMBO BOX. I have to program a database at work (within the next 8 hours), which must include lots of fields that have a code number...

I realise this has been answered, but I didn't undrestand the answer! I have to program a database at work which must include lots of fields that have a code number and a name, for example, Ship Number and Ship Name. I have a Main table containing all required fields on the form and a second...