Recent content by mkdrep
-
M
Solved Selecting data from a drop down box in one field, enters a value in a 2nd field
In my example, the county does determine the market. I'll work with your first suggestion. Thank you for taking the time to reply -
M
Solved Selecting data from a drop down box in one field, enters a value in a 2nd field
Market Area has multiple counties in it. I think I know what I need to do. Thank you for your reply -
M
Solved Selecting data from a drop down box in one field, enters a value in a 2nd field
I do not have a table which market a county belongs to, but I can easily create one. thank you for the suggestion -
M
Solved Selecting data from a drop down box in one field, enters a value in a 2nd field
I have a simple customer address form. I have a [County} field and [Market_Number] field on the form (see attached) which allows me determine where my customers are located. Currently, my employees have to select the county where the customer is located and then look on our NY State map which... -
M
Solved Trying to query two tables but get too many records in results
I'll give what you suggest a try. I do have a date time field in each table, I just didn't show it in my original email as it didn't have anything to do with the duplication issue I had. The notes all relate to one "contact" but one table is for project related notes and the other table is for... -
M
Solved Trying to query two tables but get too many records in results
I'll combine the notes into one table. -
M
Solved Trying to query two tables but get too many records in results
Actually, I do have dates the notes were made but didn't want to include it in my question as I knew it had nothing to do with my issue. I think I'm just going to combine the tables. -
M
Solved Trying to query two tables but get too many records in results
Thank you for your answer. I knew I was multiplying records but I didn't understand why. All I'm trying to do it is keep track of all the call notes we have made for one individual. Unfortunately, I have call notes for an individual in each of the two tables. In essence there are (40) call... -
M
Solved Trying to query two tables but get too many records in results
I have (2) tables as shown in (tables.jpg) which have a contact name whose ID number is the same in each table. I have drawn a dotted arrow between each ContactID, which is a FK for [tbl-Contacts].[ContactID]. If I run a separate query using the ContactID # 8311 on one table at a time, my result... -
M
simple query to update another field based on telephone numbers doesn't work all the time
Thanks for the suggestions. I'll monitor this and see if that's the problem -
M
simple query to update another field based on telephone numbers doesn't work all the time
I have a simple query which joins 2 tables by their telephone numbers. If the telephone numbers are the same, it copies the [Architect].[AIA-ID] field in table 2 (which is an AutoNumber field) into the 2nd table, [1Firms-ADD New to Firms On Project].[ArchID] field (which is NOT an AutoNumber... -
M
Update one data field based on 2nd date field
That estimate numbers i.e. 248168E are assigned by a manufacturer which sends us their estimates using 248168E....I am not creating that number, I'm just entering into my system so I can search the database using their Estimate number -
M
Update one data field based on 2nd date field
I have a quote program which assigns a master JT# for each project. Each estimate associated with that JT # receives an SL Est #. If a JT# has multiple SL Est #'s associated with it, each SL Est # starts with the same 6 digits (i.e. 248168 in attached .jpg) and then A, B, C, D depending on how... -
M
Issues with "0" in report
The attached is what I finally settled on, which gives a much clearer view than the original report. Thank you again for your help.