Recent content by theRepublic

Hey Patman, I didnt see your reply, but I solved it anyways. Your way works too. Thanks for the advice.

Hey, I solved it myself!! This is the proper code: Subtotal: IIf([DiscountRate] Is Null,[Term(months)]*[Rate],[Term(months)]*[DiscountRate]) First empowering moment in Access for a newb like me.. Later

I have taken out the "" however I get an error msg stating the following: Circular reference caused by alias 'Subtotal' in query definition's SELECT list. Here's what I know. The IIf() has three parts - condition, true path, false path. = IFF(DiscountRate is NULL), than the true path is...

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...

You guyz are nutz. I want to LEARN! haha (speaking from a newb point of view)

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...

So how do I incorporate this code into the field properties? do I copy and put this into the expression builder? And will this code allow only advertusing orders to be placed for the 1rst and 16th?

I'm a really big Noob with ACCESS, But heres my situation. I making an orders table for my dads newspaper company. The newspaper issues are printed for the 1rst and the 16th of the month. So...When a Client wants to put an order in to advertise, I am trying to manipulate the date/time field to...

I think it may have to do with the DateAdd expression. DateAdd(interval, number, date) I only want the days 1 or 16 for days. The months and year could be anything.

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.