Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Expression entered is the wrong data type for one of my arguments
When I tired the brackets Access could not find the report. however, there must have been an extra space as genomon was saying because I retyped the whole sendObject expression and sent it. No errors! Thank you very much to everyone.- MISCurls
- Post #5
- Forum: Microsoft: Access Forms
-
Expression entered is the wrong data type for one of my arguments
Still not working. Thank you for your input- MISCurls
- Post #3
- Forum: Microsoft: Access Forms
-
Expression entered is the wrong data type for one of my arguments
Good Morning all you brillant programmers out there! I would appreciate another pair of eyes on this Sub. The process emails a report to a list of email address from a table. The report iterates through the set in the table however when it finishes before closing out to the main Form it errors...- MISCurls
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Parameters query Null Error Trouble .
I took the suggestion of taking the math out of the query and running a report with a combination of the math applied in an nz function on the both the summary of the sum of quantity and grand total and an iif argument. =iif(nz([Quantity])="","0",Sum([Quantity])) -works like a dream. Thank you...- MISCurls
- Post #8
- Forum: Microsoft: Access Other topics
-
Null Error in Report revised
This is a revision to the Parameters query Null Error Trouble Thread. I changed the query and am summing the quantity in the report only. The result of the report is still returning an error when the query does not produce a value for the Brand Name field when looking between the two specified...- MISCurls
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Parameters query Null Error Trouble .
Jim, I would like the query to find all instances of the drug used between two specified dates. If the query produces no instance of the drug specified then it should return a 0 in the sumofquantity I am summing the quantity in query and then summing the sumofquantity in the report because some...- MISCurls
- Post #6
- Forum: Microsoft: Access Other topics
-
Parameters query Null Error Trouble .
Darrylle First, thanks for your reply! This worked great on the sumofquantity field -it did return a 0 for the null value however, the results for the sumofquantity that isnotnull is now summing incorrectly. A result for drug with 27 total is now showing as 2 and the sumofsumofquantity for the...- MISCurls
- Post #4
- Forum: Microsoft: Access Other topics
-
Parameters query Null Error Trouble .
I'm using a form to run a 2 parameters query on pharmacy data The query is setup like this: BrandName Generic Name Strength Quantity [Forms]![F Drug Used within Dates]![BrandName] on the brand name(combobox) field and Between [Forms]![F Drug Used within Dates]![StartDate] And...- MISCurls
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
