Recent content by George21

Are [Start Date] and [End Date] message boxes? If so try: >=Format([Start Date],"mm/dd/yyyy") And <=Format([End Date],"mm/dd/yyyy") Sent from my SM-T825 using Tapatalk

You may use dcount. =DCount("MRNO", "table name", "HAPI > " & 0) Sent from my SM-T825 using Tapatalk

Will this be done through a form? If so, for the 2nd part of your query assign default values. For the 1st a short VBA Code. Check the attached db.

I'm not sure if this is what you want (see attached zipped db). Though, as a general rule, Account Codes should be text, not long (even if they are actually numbers) for numerous reasons, and most importantly, sorting. For example, when you sort the chart of accounts you want 150001 < 160...

Will Saleh be a constant (meaning the criteria won't be changed in the future)? If so, create a query based on the table and in the emp_salary criteria write foll: >DLookup("emp_salary","emp_table","emp_id = 8")

A more correct way is to assign Index in the Orders Table and fix the relations in the query (I haven't touched the form). Check it out.

My guess would be the Criteria of CustomerID in the Query. Forms!......!CustomerID Provided the query will open after the form has been updated. Else you need to use VBA after updating the combo. docmd.openquery "......." docmd.requery

Try Isladlogs corrections without underscores. He used them because he changed lines. Sent from my SM-T825 using Tapatalk

I guess they are fields in tblDocuments as per his reply. Sent from my SM-T825 using Tapatalk

Thanks! This is helpful.

Thanks Cronk. "Aggregate Type" is what I was looking for at last! (BTW is there a site where I can see all the properties I can input through VBA)? To answer your and Ranman's question, it's true that my query is select * so I have to go through it and check some criteria before summing the...

It is dynamic because the fields are been created by another table and depending on this table's data. For example, Company A's salaries components are made of: Basic, Overtime, Leave Pay Company B's salaries components are made of: Basic, Overtime, Bonus So, now I want to make a table for a...

Hi. I have a query that I need to get the sum on certain columns. As a first step I added the following code in order to create the Total Row at the bottom. CurrentDb.QueryDefs("qryPayroll").Properties("TotalsRow") = True Since the query's columns (fields) change every time because its source...

You may use VBA. Set db = CurrentDb Set rs = db.OpenRecordset("YourTableName") If Not (rs.EOF And rs.BOF) Then rs.MoveFirst Do Until rs.EOF = True If rs("DateNameInTable") = Me.DateNameInForm Then ...

Have you tried the After Update Event?