Search results

Hey Database Experts In my query I have made a Calculated Field named "Subtotal". Here is my IFF statement for this field. =IIF([DiscountRate] =”0”, Subtotal=[Quantity]*[Rate], Subtotal=[Quantity]*[DiscountRate]) Can anyone tell me how to fix this statement? Pretty much Im trying to...

Hey Experts. Please help! I’ll try to keep this is as short as possible. I have a small newspaper company. The newspaper makes money by advertisements from local business owners. Advertisers request specific sizes for their advertisement, and pay according to its size. Typically customers...

Hey Everyone, I am working on MS Access 2007 and for some strange reason when I have created a FORM, Access wont let me move or size individual fields, without moving or sizing the entire GROUP! Also: When I try to delete a label on my form, Access deletes the entire field! Whats up with...

Hey there, This may be difficult to articulate but what I am trying to do is manipulate a Date/Time field to only display the days 1 or 16, for DD/MM/YYYY. I think in order to do this it would be in the validation rule but I have no IDEA what the expression would be. Any Ideas? Please Help.