Recent content by enc

Nice ideas. I'll look into them. Thanks.

A quick query. Just want to know if this is possible. When you create a lookup wizard you select the criteria for which the lookup is to work with and have the possibility of setting the Bound Column, Column Heads, Column Count and Column Width properties respectively. This however only...

Yes. I found that earlier and that is what I'm now using. Thanks ;)

Its to avoid numbers showing instead of names in my lookups for my forms etc. I've just realised I never searched for this topic and there seems to be a fair bit on it so I'll give some of the previous suggestions a whirl.

I don't know if this is a bit far fetched or even possible within Access but for this reason I post here in hope somebody will understand my predicament ;) I've basically got a sports league database. One of my tables contains a complete list of every team in the league and this is the tables...

Hmm. Interesting concept and clearly works. Means I may have to have a re-design of my database though. Agh! :rolleyes: Thanks for that though. And thanks for sticking by.

Thanks for trying but you're mis-reading the question. I basically need a formula that will count, for each team, how many occurences of a number is shown.

I already do use a table to store my game results. The query I posted above is generated on comparing two fields to find out whether each game has been won/drawn/or lost and therefore assigning points. This is not a problem. My problem is I need to count the number of occurences of a number...

I'm having alot of difficulty with using the DCOUNT function within a report in my database. I am creating a sports league and the report in question is to show the league standings. I need to display how many games a team has won/drawn/lost respectively. One of my queries is designed to assign...