Search results

In a "No change sutuation" sutuation If it is a "No Change" sutuation is it possible to dertermine whether it is a "win" or "loss" on another value. For example if another value in another field is a minus then the "No Change" value is a "loss" again" and visa-versa for a positive. But if it is...

Back to the IIf function If the value is neither a minus or a postive as you said is it possible in this sutuations to dertermine if its a win or a loss from working out another calculated value.

Kind of Works It does work but it asks me to enter the score. When I type Ok without typing anything the function works. Is there any way I can get rid of the command asking me to enter the score?

I'm trying to write an equation in one of the fields in query which will automatically change minus values into a text displaying loss and any positive values into text displaying win. Any help will be greatly appreciated.

Hwo can I round off numbers in a query field

Abs( )Function Can anyone tell me what a Abs() function is and how I can use it in a query field to change negative values into positive values. Thanks

Sorry I don't fully understand what to do could you explain to me how to do this

I have added all the true values in a field in a query is it possible to change these values from negative values into positive values.

I have a query and in one of the fields I want to count the number of True Values that have been chosen. How do I do this?

I have a query and in one of the fields I want to count the number of True Values that have been chosen. How do I do this?

I doing a soccer team database. In the database there is a team form which is based on a team table where the user can select 11 palyers for a particular fixture. The 11 palyers are picked by using combo boxes and I was wondering is it possible for the user not to select the same players. Is...

I'm writing a a database for a soccer team and I'm having a problem with a query. The structure of my database is that I have a team table where I select 11 players for a particular fixture. I have written a query which shows the players that have been selected for a fixture. Its a select query...

I wrote this macro which doesn't show the subforms if there is no data in them. The macro is:- With Me![frmBowling].Form .Visible = (.RecordsetClone.RecordCount > 0) End With With Me![QryAverageBowling2].Form .Visible = (.RecordsetClone.RecordCount > 0) End With End Sub Is there any way in...

6 tables I have 6 tables. the important one being for this for this problem tblFixture which contains all the fixture details, tblTeam which contains all the Players chosen for a particualr fixture and tblAvailable which is based on a update query which updates all the available players.

I'm making a database for a cricket club. I have a team table where I select a the players for a team in a ceratain fixture. I have also written a query which only shows the players that haven't been selected to play (this is called QryAvailablePlayers). In the team table the only players I can...

How do I hide a sub-form if the number records to be displayed in it is zero i.e how do I stop blank sub-forms being displayed?