Search results

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

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

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

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