Recent content by bbulla

Hi MajP, Yes, specifying each field with the ALL_WR_Table.<fieldname> solved the problem. In Access it would just show both of my FACILITYID fields (one from each table), with no error message. Thanks for your help!! It's nice to get this working.

To follow up on this, I have gotten a single query to work in MS Access: SELECT * from (SELECT works_INSPECTIONS_HYDRANT_INSPECTION.* FROM works_INSPECTIONS_HYDRANT_INSPECTION WHERE (((works_INSPECTIONS_HYDRANT_INSPECTION.DATEWORK) Is Null) AND...

Yes. I can connect to all the tables through MS Access....ODBC Connection.

Thanks Plog. Yes, ArcMap is not the best for querying data. Even just trying my first query to show only the most recent inspection keeps crapping out in ArcMap. I think it doesn't like the Max operator on the date field. Anyways, I will keep plugging away. The end goal is to create a query...

Hi, Thanks for the responses. The reason I need this to work in a single query is because I need to query the inspection table through an application called ArcMap, and it will only allow me to enter a single SQL statement. The actual table is really stored in a spatial database, so I guess...

Hi, Currently I am using 3 queries to come up with the results I am looking for, but I would like to figure out the proper way to combine these 3 into 1. What I am doing is looking at a table of inspections and picking out the ones that meet a certain criteria. Here are some details: My...

Hi, In my report when the Group Header and the Detail section will not fit onto one page, it prints the Group Header on one page, and all of the Detail on another page. Is there a way to keep them together? I have already tried the 'Keep Together' option in the Sorting/Grouping window...

Ah.....your a genius! I guess since I am using a tab control, I needed to reference the main form first (not 'me'), and then work my way back down to the subform. Thanks for your help!

Still no luck: =me!subfrmLABOUR.Form!txtTotalHours.Value gives me the same error as before. The strange thing is that if I create a button on the main form and have a Click event like this: msgbox Me!subfrmLABOUR.Form!txtTotalHours.Value it works!! Is there a property of the text box...

For some reason I can't get this to work: I have a form, with a tab control on it. Each tab has a subform to display data. One tab is meant to be a summary tab of the rest, so I want to pull data from certain controls on each of the other tabs to display on the Summary tab. If I set the...

Excellent. Thanks for the step-by-step Plog. I was then able to summarize that and created another query to show the count of each count: ie. total # of 0 occurences, etc. Thanks for the help!

Hi, I have a Table A that is a list of ID's. In table B, each ID (from A) could appear mutliple times, or not at all. How do I get a count of how many times each ID in Table A appears in Table B? ie. 0 or 1 or 5 or whatever Thanks,

Hi, I've done loads of research but still find dates, specifically dd/mm/yyyy dates, confusing. Here is what I have: Table FLUSHING with a date field called FLUSHDATE, format set to dd/mm/yyyy. If I make a query through the GUI (ie. Query - New), and enter the 'Criteria' for the FLUSHDATE to...

Hi Mr. B. Yes, I tried that also but it doesn't seem to work either. The label is still visible.

Hi, I have a label (lblDate) in the page header that I want to be visible on all pages, except for the last page. I have tried lblDate.Visible = Not (Me.Page = Me.Pages) in the PageHeader_Print section, and a few other things, but nothing seems to work. Any other ideas?