Recent content by aussiehedge

Mate you are the best! I can believe i was stuck on that for days. changed the indexing to no duplicates and bang all fixed!

I have read many post on this and I just cant crack it. Not understanding vba well i have tried to copy paste and adjust. I need to filter a subform based on 3 combo boxes. The main form is LCLForm and i have attached a copy of the database. The filter should kick in after the After update on...

I would like to retur these records only if they have more that 6 charaters Like [Forms]![Class1]![Subheading Query subform].[Form]![heading] & "*"

I have managed to filter as required by using SELECT Min(class.heading) AS MinOfheading, class.Option FROM class GROUP BY class.Option, Left(heading,6) HAVING (((Min(class.heading)) Like [Forms]![Heading]![headingrequery].[Form]![Heading] & "*")); The problem i have now is i cannot use the...

Can you please assist. I need to only show the first record of a new sequence in a query. I have put a star against the records i need to filter. The length of the record may be different. At the moment i use this to show all the records Like [Forms]![Heading]![headingrequery].[Form]![Heading] &...

I have read many articles and it just dosnt work for me. I am trying to refresh a subform when the check box is ticked on a single record in the subform to remove that line to limit the results via a query. I have the following in After Update Private Sub Option_AfterUpdate()...

=DSum("[SumOfPackages]","Total Charges For mode count","[Port Of Loading] = " & Reports!Test3![Port Of Loading] And "[Mode]=" & Reports!Test3!MODE & "'") Tried this, still not working the port of loading and the mode are both text fields. Entered and between them as it should match both.

i have a query called "Total charges for mode count" with 3 columns SumOfPackages, Port Of Loading, Mode In a report i am trying to lookup from this query that is not bound to the report and add the total number of packages. The report contains two groups Port of loading and mode. The lookup...

I am trying to count the number of records on a report in the footer of two groups. However i need to count the records with the same job number as one. i cannot group these in a query as all 203 records have different information that cannot be combined. The two groups are 1/Port of loading...

I need to sum specific records that contain DAHF and DIDF they are from the same table Column that has different codes eg FRT and DIDF. To get the local sell amt. The table name is [Charge Code] I have tried the following =Sum(IIf([Charge Code] = "DITF" Local Sell Amt],0)) This returns DITF...