Search results

Thanks Everyone!!! It turns out limiting it by First() worked. I was having problems when I tried it because I was asking for the First(TeamID) when I should have been asking for the First(Captain). Thanks again for everyone's input!

Okay, here's my problem. It involves two tables: Teams, Captains. There is a one to many relationship from Teams to Captains. Here's the problem every time I create a query to show the teams and list the captains that belong those teams I get double listings or triple listings depending on...

Got It!!! Thanks for all your help Tim. Cheers.

I GOT IT!!!! Thanks Tim. It was a matter of how I was inserting the module into the report. Whew! That took a while. Thanks for your help.

oops! It should read http://a.parsons.edu/~torres/data/db1.zip

Ugh!! Tim, Thanks for your very helpful suggestion. I tried it with dummy data, very simple stuff, but it still doesn't work. What am I doing wrong? Here's my file. http://a.parsons.edu/data/db1.zip Thanks again.

Thanks Tim. I 've tried that. But it still prompts me to "Enter a Parament Value". I feel like I'm missing something obvious. But I just have no idea what I'm missing.

I have scoured the web and found several seemingly useful modules to calculate the median of a set of records, but I can't get any of them to work. The latest one I tried I found here (http://support.microsoft.com/default.aspx?scid=kb;en-us;q210581) I followed the directions to the T, but when...

I still need help Thanks for your reply Neil, but I'm still not able to make it work. What I would like to happen (ideally) is that once I enter a new building a new floor (named something default like the name of the building) would automatically be generated, which would automatically...

Okay I am pulling my hair out because I can't wrap my head around this one, and I swear it's got to be so easy. Please help! Here's the situation: 4 tables, each a successive 1-to-many relationship. like so: table 1: ->Building fields: ->BuildingID - AutoNumber ->BuildingName table2...