Search results

Hello, I have a table with an ID field and a text field the user enters the text and i want to find the id for that text in my table stampnoT text field is stampno In another table called stampholdert i have the ID as a foreign key called stampnoid this is bound the id field i want to...

Hello I have a report and made a textbox with the control source =dsum("QTY","[JobsT]", "InspectionID = 1") so QTY is in the JobsT and in a junction table i have InspectionID that is linked by jobno. If i set the report recordsource with the fields it returns the result. When i use the formula...

Hello, I am having trouble with this formula not giving me the q2 results of last year. It still give me the current year results =DSum("[QTY]","[InspectionsT]","[TaskID]=3 And Datepart('q',Dateadd('yyyy', -1, [DateCompleted]))=2") Any help would be greatly appreciated

Hello, I am trying to add up records with the quantity of and then if the quantity is greater than 1 add that to the count. So the single record is counted as many times as the quantity says. If i have 12 records all with quantity 1 then that would be 12 and then if i had 1 record that had a...