Search results for query: *

Hi Dawn - If you have nothing joined by the offending text field and no selections based on this field, then it's necessary to see the SQL to determine problem. If you have joins on this field, then the "+" made this field not match corresponding fields in the joined table(s) and...

Hi Petzl - How about separating the 9-position postal codes into a table called "Addreses". The postal code could be the key and the fields would be StreetAddress; City; State; and, if there is info that is particular to a suburb other than city and state, SuburbID. Then your...

Build a Customer table which has customer name, address, contact, phone, email (or whatever information you need about customers that doesn't change from job to job.) Put "Customer ID" as a non-key field in the Quote table with allowable value of null. On the form where you enter new...

Create three SELECT queries from your new table that group employees by: 1) country 2) country and organization 3) country, organization and site Make COUNT as one of the output fields in these queries. Create another query that joins the new table with these 3 queries. COUNT is the...

To void using VB you can 1) Create an append query with an outer join on CustomerID from tblCustomers to tblOtherTable1. Add selection criteria on the CustomerID field in tblOtherTable1 to select records when it "is null". Append records from tblCustomers to tblOtherTable1. 2) Create...

I get this error when trying to perform a 1) a compare in an IIF statement between a numeric and non-numeric field, 2) a calculation using a non-numeric field and 3) a selection based on dates. The offending field, which Access looks at as non-numeric (or "non-date"), always comes...

FYI ON DATEDIFF FUNCTION: If the result is over 999, it returns 0. Workaround is Format(DateDiff("d",[BegDate],[EndDate]),"0000") This is in Office XP. I don't believe I used datediff in previous version of Access so it may be okay in them.