Search results

Thank you! I understand the reasoning behind the query and hope to apply this methodology in the future. The results are great. Thank you again!

That fixed it! I noticed when I scan a second bag, it enters the information into the table [tblPropertyDetailsDummy] with no issue, but it will not update both records in the table [tblPropertyDetails], it will only update the last record scanned, leaving the previous unchanged even though...

Sure. The query that I have been testing is: [qhelp3] The Query should return this instead of the previous: Site Personal Medication Money Seized Property Total "" 0 0 0 0 0 "" "" North 1 1 0 0...

My results are still off by duplicating whenever a site has a property

I added: Status as a field, total: Group by Kinda does what i want, but it duplicates the values on the results. TRANSFORM Nz(IIf([tblStatus].[Status]="Processed" Or [tblStatus].[Status]="UnProcessed",Count([PropertyType]),0),0) AS Expr1 SELECT qsites.site...

I got a compile error: Method or Data member not found? Any suggestions Private Sub Command8_Click() Dim dbs As Database Set dbs = CurrentDb dbs.Execute ("UPDATE tblPropertyDetails INNER JOIN tblPropertyDetailsDummy ON tblPropertyDetails.PropertyID =...

I get an error saying you tried to execute a query that does not include the specified expression as part of an aggregate function. SQL: TRANSFORM Nz(IIf(tblStatus.Status="Processed" Or tblStatus.Status="UnProcessed",Count([PropertyType]),0),0) AS Expr1 SELECT qsites.site...

That also works great. I was attempting to further narrow down the results by status, making only "Processed" or "UnProcessed" for the criteria. When I add this, it only shows the two sites where the property is marked either "Processed" or "UnProcessed", removing the rest of the data. Any...

So far everything works great. One question, would it be possible for me to move: Private Sub Form_AfterUpdate() Dim dbs As Database Set dbs = CurrentDb dbs.Execute ("UPDATE tblPropertyDetails INNER JOIN tblPropertyDetailsDummy ON tblPropertyDetails.PropertyID =...

Works great.... the final result for the detail section: =CInt(Nz([Personal],0)+CInt(Nz([Medication],0)+CInt(Nz([Money],0)+CInt(Nz([Seized Property],0))))) final result for the footer: =Sum([Personal])+Sum([Medication])+Sum([Money])+Sum([Seized Property]) thank you very much!

That worked great! Guess I was over thinking a simple thing. With the crosstab, I was attempting to calculate the totals. I am able to do this fine in the report footer for each text box of the details section. Is it possible to also sum each individual row? When I attempt to add together...

I have been working on a crosstab query where my text value (not a number) will not return a 0 instead of a null value. My expression that returns the crosstab value is: Expr1: Nz(Count(IIf([PropertyType]=" ",0,[PropertyType]))) The PropertyType can be "Destroyed" or "Turn Over". Am I...

I will need more time to test. Can you explain what you did, and the idea of the dummie table to help me better understand the flow! As of now, it works pretty darn good!

Thank you for the reply. I tried that earlier but it still writes the data to the table as a new record. I only want to update the exisiting record. I would need to edit the TurnoverTo, DateOut, and PropertyStatus of each record in the subform. For example on my attachment, the PropertyID is...

JHB, Attached is a 2000 and 2003 version. Pat, Maybe that is why I am having trouble, but I thought foreign keys were the only duplicate values / relationships i have among my tables. I am stumped as to what is needed to be changed. When opening the database, I have arrows indicating the...

Happy Friday All! My issue: I have a DLookup-After Update event on a continuous subform that will not allow me to edit the values and continue to the next row. I can edit the record persay but when attempting to move on to the next row in the subform to pull another record, it tries to save...

Jdraw, From my 1st post where I attached screen shots to duplicate the issue:-) The idea here is to release the property bag to whomever, and track who it was released to and when. This form is to scan many property bags out at one time, 25+. From here, I will open a report that logs all...

I had no duplicates originally, later taking it out, and now putting it back. The index now reads: Indexed – Yes (No Duplicates). The main issue is that after moving to the next row, it attempts to add the record from the continuous form to the table, rather than updating the record. I...

I edited the DB on my first post to remove the duplicated values in the table. On 2.jpg, step 4 is when I have entered the bag number and tabbed my way to the next row. When you click or tab to the next row, it adds the duplicate value in the table with the new Property Manifest Number on the...

I am running into an issue when I run an AfterUpdate event on my subform, which is a continuous form (ugh - i know, but couldn't think of an alternative way to do what i wanted). After the event and moving to the next row, it duplicates the table values. Is there a way to prevent this? What I...