Search results

Is there a way to allow an Enter in a textbox as opposed to an enter tabbing to the next control? I'm hoping for Ctl + Enter functionality with just the Enter.

Paul, That did the trick, thanks much!

Tim should equal 2 (1 and 2). I'll give the SQL and [NAME] suggestions a shot on Friday. Thanks gents!

I have a query that includes [NAME], [INCIDENT] and [CLASS]. Can anyone show me an example of doing a query that would give me a count of unique incidents by unique name? For example, my data might look like this: NAME INCIDENT CLASS TIM 1 x...

I ran query 1 again and low and behold 112 records were returned (I'm running the query on a live database so this makes sense). I ran the union all again and everything is as I expect. You're awesome! Thanks Again!

Thanks for the response! I tried that and it yields me 319. I'm confused. :o

I have a 2 queries set up each with identical field names, one that returns 110 records and the other that returns 207 records. I have set up a 3rd union query that looks like "SELECT * FROM Query1 UNION SELECT * FROM Query2;". This query return 315 records when I'm expecting 110 + 207. Is...

Well, actually, I have several fields (including the incident field) that are unique. I'm intending my report to show multiple incidents per address, what the incident number was, type, date etc. The report also displays the total number of incidents for each address via "=Count([Address])"...

Yes, I have a field [INCIDENT] which is a unique id. Is there a way to get the count without doing 2 separate queries and joining them? Or, getting back to the report, if I have a text box in the ADDESSS Header of my report with a control source "=Count([ADDRESS])" is there a way to say if...

Thank you, that gives me a lot to play around with. What I'm not understanding with the count is when I do it I get a count of "1" for every record but I was imagining getting a total number of occurrences. For example, imagine my table has 3 records. Record 1 has an address of 123 Main...

Again, pardon my ignorance..... This is the query I'm using: SELECT [Repeat Locations].INCIDENT, [Repeat Locations].DEPTCLAS, [Repeat Locations].ADDRESS, CDate([Repeat Locations]![OFMONTH] & "/" & [Repeat Locations]![OFDAY] & "/" & (2000+[Repeat Locations]![OFYEAR])) AS [DATE], [Repeat...

Pardon me if this is a simple question. I have a report that shows each occurrence for an address and I'm doing a count([address]) to get the total number of occurrences for each address. How can I filter the report so that it only shows the addresses and occurrences where the count > 1 (I...