Search results

Not sure that's going to help as the data is the same from both, just with the count column, but :- QUOTEID CUSTOMER_NAME BROKERAGE_NAME REQUESTED_SSD 961945 Cust1 Bro1 06/10/2017 and quoteid customer_name brokerage_name requested_ssd XCOUNT 961945 Cust1 Bro1...

Hi all, Is it possible to add a column to the below to record how many instances of a matching customer, for the same broker occur on the same date :- SELECT q.QUOTEID, c.CUSTOMER_NAME, b.BROKERAGE_NAME, q.REQUESTED_SSD FROM ((TBLQUOTESNEW q LEFT JOIN TBLBROKERAGESNEW b ON q.BROKERAGE_ID =...

Great - thank you

Honestly, I just used those dates as an example. If I was fortunate enough to get an answer, I was going to apply the methodology to what I require. That aside, I need "today" and "yesterday". So, Today Yesterday 123 456 Thanks

Hi all, The following gives me a count for a specific date SELECT Count(d.DATE_SENT_TO_REGISTRATIONS) FROM tbldata d WHERE (((d.DATE_SENT_TO_REGISTRATIONS)=#9/25/2017#)); How do I need to adapt this so I have 2 columns returned, and the second column's data being for the date 9/24/2017?

Yep - The driver is Oracle in OraClient11g_home1 both on my machine, and the user's.

I've tried each of those options, and the user is still having the same issue.

Hi, I have an Access front end, used by around 10 people, which has around 20 linked Oracle tables. Every user is using the same version of the front end. Only one user in particular is having an issue. When they try and change values in the tables, they get ODBC errors, and DUMs, etc return...

This is exactly what I needed. Thank you for taking the provide such a thorough answer, it's really appreciated.

Sorry, maybe I didn't explain myself very well. Each quote potentially could have a cost at stage 1-6. Null should only e returned if there is not a cost associated with that stage More sample data is :- 35235 / Yes / No / No / No / No / No 35236 / Yes / Yes / No / No / No / No 35237 / Yes /...

Hi, I have the following query which returns Yes or No if a Stage value is found in tblCommissionNew SELECT Quote_ID ,Max(IIf(Val([Stage]) = 1, 'Yes', 'No')) AS Stage_1_Calc ,Max(IIf(Val([Stage]) = 2, 'Yes', 'No')) AS Stage_2_Calc ,Max(IIf(Val([Stage]) = 3, 'Yes', 'No')) AS Stage_3_Calc...

They do have the same fields. There is a CONTACT_TYPE field in tblcontacts

Hi, I have a feeling this should be simple, but for some reason it has me stumped... I have the following 2 tables (and fields) :- tblquotes QUOTEID CUSTOMER_CONTACT_ID BROKER_CONTACT_ID tblContacts CONTACTID A quote can have just one Customer contact and one broker contact. Both Customer...

Perfect - thank you (again).

Sorry, what I'm actually after in unique QuoteIDs. My sample data is entirely fictitious, so I over simplified. But, using your data, I'd like the below returned :- QuoteID 456 789 As neither over those has a 16 PetType. Thanks, and apologies.

Hi, I have a table in the format below (with sample data) tblquotes QuoteID / PetType 123 / 16 123 / 16 123 / 17 456 / 14 789 / 15 How can I distinct rows where a PetType of 16 does not exist for a QuoteID? So my returned results would be :- QuoteID 456 789 Thanks in advance

Great question. When I first started using Access, I didn't know I could add images to buttons, and used images as buttons instead. I've now changed all my images to buttons with images, and it works great - thank you.

I have so few images, and the selected images are so obviously buttons, that there's never any confusion I do like this idea though - thank you.

Yeah, I disable some other things at the same time, so I could do an IF on that. Thanks