Search results
-
P
If Function
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. -
P
Abs() Function
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 -
P
Mile-O-Phile- Abs() Function
Sorry I don't fully understand what to do could you explain to me how to do this -
P
Change Minus Values into Plus Values
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. -
P
Count True 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? -
P
Count Yes/True 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? -
P
Combo Boxes
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... -
P
Soccer Team
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... -
P
Message Box
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... -
P
Update Queries
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...