Search results

As said, you can't actually do this in one query. If you really want to, you can try something like: SELECT SectionName AS [Section/Employee], Count(EmployeeID) AS [Employees/Phones] FROM SectionT RIGHT JOIN EmployeeT ON SectionT.SectionID = EmployeeT.SecIDFK GROUP BY SectionT.SectionName UNION...

Try LST: IIf([Mastertbl3.calldate]>#3/12/2022# OR [Mastertbl3.calldate]<#11/5/2022#,"Yes","No")

And also crossposted at https://answers.microsoft.com/en-us/msoffice/forum/all/validation-rule-to-prevent-auto-populating/f7a6a0db-aa9f-49c9-8f66-3161ecb269b9

So that's exactly what I mean. If you can deduce the value of the flag from the presence of a discount ID in a certain table, then that flag is superfluous. If you want to know somewhere in a process whether the discount can still be applied, you only have to check the ID. The danger of your...

Perhaps you should first explain a bit more about the purpose of your database and the meaning of the fields. Then maybe I can explain more precisely what I mean.

I wonder if you really need the field you're updating. If you can deduce the value from other values or conditions, then we are dealing with a derivable data and that should not be stored. This makes the code superfluous.

Maybe you can use a (bound) discount field?

Maybe you can try to use a union query as the rowsource. Something like SELECT ID, CustName FROM tblCustomer WHERE Preferred = TRUE UNION SELECT ID, CustName FROM tblCustomer WHERE Preferred = FALSE

Make sure the date is locked on the form.

First of all I don't think you need a tick box and a date. Just a date will do. If there is a date, the record is submitted. You do not need a update query. Let the button just update the date on the form (me.SubmissionDate = Now())

First thing we need to know is: what are duplicates? Even If we leave out the ID there are no 2 records that are exactly the same (see the time differences in Data_ora). An other point is: are there tables related to this table? You can't remove one of the "duplicates" If the record is a...

This is a the SQL for a query. You can use this SQL as the recordsource of the report. Or make a query with this SQL and use the qeury as recordsource for the report.

I posted a complete query. Not just a part of your query.

UPDATE [Transactions - Procurement - Temp table] SET Currency = DLookup("Currency", "Table4")?

Please be more clear. Which table do you want to update? If you want to update one table, why do you make a query with 3 tables? If there is no joint field in "table4" how can you find the right value? But most important: explain the purpose of the tables and the logic behind the update you...

A SELECT Stock_Name, Sum(TransactionQuantity) AS SumOfTransactionQuantity FROM Investments_Purchases_SalesT GROUP BY Stock_Name B SELECT PortfolioCode, Stock_Name, Sum(TransactionQuantity) AS SumOfTransactionQuantity FROM Investments_Purchases_SalesT GROUP BY PortfolioCode, Stock_Name You will...

This would be my suggestion I don not see the need to have a many-to-many relationship between project and complaint. Each complaint belongs to just one project. In t_test you find general descriptions of all possible tests. t_test_comp tells you which tests are run for a complaint. I don't...

First of all I think the after update event will not work. You do not change the customer name, so the event won't fire. A requery of subform-2 will also only work If the recordsource of the form refers to the selected customer. Without knowing that recourdsource, I doubt this will be the case...

Thanks, that works.

I use the Dutch versions of Access and Windows. That means that the decimal separator is set to a comma by default. In a table I have a numeric field (single precision). Entering and displaying values works fine for this field. However, if I use the field as a condition in a function, I get an...