Search results

I guess I don't understand. Could you please show and example?

InvoiceDueDate: IIf([payment terms]="NET 30",[invoice date sent]+30,IIf([payment terms]="Net 45",[invoice date sent]+45,IIf([payment terms]="Due Upon Receipt","Due Upon Receipt Past Due","UNKNOWN")))

The error I get is below. the expression you entered contains invalid syntax you may have entered an operator such as the + operator in an expression without a corresponding command I am trying to add 30 to NET 30 terms and add 45 to NET 45 terms; to give me the date the invoice is due.

Hello, How can I use 2 ++ on one line in a query? Thanks, Holly

This is the full code. PaymentStatus: IIf(Date()-[invoice date sent]>=1 And [tbl report and invoices sending]=[due upon receipt],“Due Upon Receipt Past Due”, IIf(Date()-[invoice date sent]>=365,"365 Days Past Due",IIf(Date()-[invoice date sent]>=180,"180 Days Past Due",IIf(Date()-[invoice date...

Hello, I am trying to return records that are past due if not paid right away when the invoice terms are “Due Upon Receipt” below is the code I’m using. I keep getting an error saying you entered invalid syntax. Any ideas? PaymentStatus: IIf(Date()-[invoice date sent]>=1 And [tbl report and...

Maybe this would make more sense? TotalRateAllPositions: (IIf([CABIHours]>8,(500+([CABIHours]-8)*93.75),[CABIHours]*62.5),IIf([ProjectManagerHours]>8,(576+([ProjectManagerHours]-8)*95),[ProjectManagerHours]*72), IIf([AMSHours]>8,(576+([AMSHours]-8)*95),[AMSHours]*72)))) I keep getting a coma...

I do have a table that holds the hours and type of hours. If I did have a module for this; what would that look like?

Below is the expressions broken down into 1 column each. CABIHours: IIf([work hours]![work code]=60,[hours]) CABIOTHours: [CABIHours]-8 TotalCABIRate: IIf([CABIHours]>8,(500+([CABIHours]-8)*93.75),[CABIHours]*62.5) ProjectManagerHours: IIf([work hours]![work code]=14,[hours])...

Perfect Thank you so much!!!

I need a query to calculate the following. TotalProjectManagerRate: IIf([ProjectManagerHours]>8,(500+([ProjectManagerHours]-8)*95),[ProjectManagerHours]*72) I need it to be able to take those 8 hours or less and multiple them by 72.00, and take anything over those 8 hours (example 2 extra...

Perfect thank you! I have one more question. I need to calculate 2 more categories. Below is the expression I have. But they are not calculating properly. TotalProjectManagerRate: IIf([ProjectManagerHours]>8,(500+([ProjectManagerHours]-8)*95),[ProjectManagerHours]*72) TotalAMSRate...

I need a query to calculate the following. CABIDayNormalRate: IIf([CABIDayHours]<=8,[ CABIDayHours]*62.5) CABIDayOTRate: IIf([CABIDayHours]>=8,[hours]*93.75) When I run the query. It’s only calculating if there is less that 8 hours. I need it to be able to take those 8 hours or less and...

Also the form is based on a query.

Wonderful idea! How would I link the timecard form with with the table in my original database?

Hi Jeanette, I believe the user name a password would be the way to go. When writing the code to hide all the forms except for the time sheet. Would I need to list each hidden form(there are more than 50)? Would you be so kind to send me all the steps involved in this process? Thanks, Holly

Hello, I would like to be able to have an individual form that people could use as there time sheet. This form would need to be separate from everything in my database. I don’t want these employees to access to the rest of my database. Is this possible?

Never mind I figured it out. Thank you so very much for you help, it is greatly appreciated.

Ok I almost have it working perfectly. I just need to know how to have the file path name the folder with the ProjectNumber and PropertyAddress. I think it should to on this line. strPath = strRoot & "\" & "0" & strProjectNumber & "\" Any ideas?

I set the event to “on open” and I get the same error message on the same line. I could send you the database if you like. Private Sub Report_Open(Cancel As Integer) 'Sets report caption name according to the project number Reports!rptworkauth.Caption = [tbl Work Auth].[Project Number] Dim...