Search results
-
A
IIF Statement in a Select Query, Access 2003
Basically I have 5 different fields for proposal quote prices- PropAudit PropReview TaxOnly Other Amount Discount Amount $1,450 $875 $300 $0 $50 The field [Job Type] is a drop down Combo Box that lists- Audit AuditNTX Review... -
A
IIF Statement in a Select Query, Access 2003
Hello, I know this will probably be a quick question for someone with good knowledge with Access Query's. I am trying to make a query that will calculate fields like this-- Expr1: IF ([Job Type]="Audit" OR "AuditNTX" THEN [PropAudit]-[Discount Amount]) ELSE IF ([Job Type="Review" OR... -
A
Date formatting issue Access 2003
Thank you I will give that a try. I also just found some information on parameter query's that I am going to look into. Apparently you can have the Query prompt you for the two dates to be inbetween. -
A
Date formatting issue Access 2003
Hello, I am having an issue where I am trying to make a date in a certain field not contain the weekday. I am running a query and I will need to select from a period of time from 1/1/08-12/31/09. I am wondering how I can remove the weekday from the date. The format for long date currently...