Search results

yeah it has curly brackets i couldn't get '' or removing the brackets to work so i changed the way i did it with recordsets instead and finally gt it working.

I got it working using recordsets, the reason i used a replicationID was because you can have infinite records whereas using an integer there seems to be a maximum number limit i think. A guy at work built a 1 table database in access and one day we could not create any more records. We had to...

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

I am not sure that would work. As say the job comes in 2 x for a stage inspection, then it comes in for it's final inspection. I am just wanting to count the qty to give a total of stage inspections and a total for final inspections.

This is a guide to what I have done, i have not got my database from work here. As it is hard to get it back into work. Hope this helps

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

I have 8 textboxes each with different quarter in them. 4 for last year and 4 for this year on a form. As they are just calculated fields from the data in the table. I couldn't think of any other way to do it

I solved it wit this =DSum("[QTY]","[InspectionsT]","[TaskID] = 3 And Datepart('q',[DateCompleted]) = 2 and Datepart('yyyy',[DateCompleted]) = Year(Date()) - 1") splitting the year and quarter

I have tried examples for example =DateAdd("yyyy",-1,[DateCompleted]) still does not like it. I have not seen any other examples with different syntax.

yeah it looked ok and the rest of the formula has been working with datecompleted field.

The part that is not working is this part =DateAdd('yyyy',-1,[DateCompleted]) i get #name?

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

Because i was only counting the tasks that equal final, sorry about not making that clear

Thanks i think i have it now. it was because i was adding up records then added a qty field and got stuck on counting records

Thanks i will give it a try

I tried with iifs dsum and then a dcount as i want the total number of records but it had issues with the formula

Not sure how to ad da database file, i want to add up all the finals which would be 5 even though there is 3 records. Normally i count the records to provide a total, but if the qty is >1 then that will count in this case as 3 records instead of 1. Hope this helps clarify things

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