Search results
-
O
Strange summing results in a report
Hi, I have a report that derives it's data from a query, one particular field is giving strange results under certain conditions; 1. The field in the query contains this formula - Vol: IIf([grade]="P",DLookUp("volume","tblpoles","length =" & [length] & " And " & "cdub =" &... -
O
Relationship design
I am designing a db from an excel file that a volunteer org uses, i am the treasurer and I believe what they do in the spreadsheet would be easier in Access. I am familiar with tables, queries etc. Where I am getting stuck is the relationships and getting it to work properly. The database would... -
O
Conditional sum problem
I have searched on Sum and DSum but cannot find anything that is relevant to my problem. I have a report which is derived form a form/subform. The main form has a unquie ID number amongst other fields, the subform has grade, volume and price fields among others. A report is derived from a query... -
O
Can I use Iif for this?
I have a working query which has 3 fields derived from a table - Length, Grade & CDUB, following those fields I have a calculated field which is RAD that contains a formula RAD:=[CDUB]/2, following that another calculated field which contains VOL:=3.141593*[RAD]^2*[Length]/100000. Now I want the... -
O
To mde or not to mde
Hi, I have created a fe/be database, now my problem is that I want to make it secure and I thought creating an mde would be just the ticket but the client I am creating it for is running access 2000 and I have created it in access 2003 under XP Pro but in 2000 format, when I go to create the mde... -
O
filled text boxes based on combobox choice
Hi I have been searching this forum for 3 hours for a solution, some come close others are pure gobble de gook to me. I have on a form 1 combobox where a name is chosen, from that choice I would like the address, suburb, state etc automatically placed intheir relevant fields. I have tried... -
O
Sums depending on grade
I have created a logging report that shows the records from a form, the fields are Species, Length, CDUB, RAD, VOL, Grade I need to sum the VOL of each Grade, so if a row has the grade "O" include it in the sum. there are 5 different Grades so I will need 5 formulas. I tried this...