Recent content by cj_steve

hello, I have a table that contains some of the following fields, where the field Free is a Yes/No Data type and Quantity is a Number type. Free Quantity 1 10 X 1 X...

Ahhhhh, got it. I changed the name of the text field and it worked the value name and the text name were the same. Thank you!!!

Hello, I have a report whose record source is a query that contains 3 tables, with one of the fields named SUM. Basically these are invoices and at the end of the report I want to print the value of the field SUM. In the Page Footer I have a text box whose value is...

Hello, I have a form with 2 fields city and city code. I have a lookup table, County, that has the values for city and city code. When the user selects the drop down list for city and chooses a city, I also want it to automatically fill in the city code field. How would I accomplish that...

Hello, I have the following equation in the control source and it works: =DSum("[Amt of Dues]","City","[Amt Paid]=0") However, I also need to add another criteria to the above equation regarding dates, I have the following equation: =DSum("[Amt of Dues]","City","[Amt Paid]=0" And...

Thanks, the Nz function is much better. However, I now get #Error where I should have the sum. I am using the following equation =Nz(DSum("[Amt of Dues]","City","[Amt Paid] = 0 And [Date Pd] <= #" & [Reports]![Combined Dues Ending]![Select_Date] & "#"),0) Thanks

Some sql code might look like Select Sum(Amt of Dues) From City Where Amt Paid = 0 AND Date Pd <= :Select_date; Thanks

Ok, I have fixed the syntax errors; however it now doesn't seem to be paying any attention to the where clauses, it just gives the sum of Amt of Dues irregardless of the Date and Amt Paid = 0 restrictions. =IIf(DSum("[Amt of Dues]","City","[Amt Paid]=0" And "[Date Pd]<=" & "[Reports]![Combined...

Hello, I have a field in a report (Combined Dues Ending) that reads: =IIf(DSum("[Amt of Dues]","City","[Amt Paid]"=0") Is Null,0, DSum("[Amt of Dues]","City","[Amt Paid]=0")) where Amt of Dues and Amt Paid are in the City Table. I need to add another condition the to the Amt Paid = 0...

Got it!! Many Thanks, I added "[County]![Date Pd] and that seems to work. Thanks again

get prompted for me variable Hello, Thank you for your response, When I use the following =DSum("[Amt Pd]","County", "[Date_Paid]<=" & Me.[Date]) I am prompted for a Me variable. More information: The field [Date_Paid] is also located in the County table. The variable Date is located on...

Hello, I am editing a form and there is a text box with a Control Source listed as: =DSum("[Amt Pd]","County") I need to adjust this statement where the field Amt Pd is based on a date field in the table named Date_Paid and a Date Field the user enters - Date. In Sql it would be something...