subtracting childnumber from another field

Hi,
where do you want to calculate this value? Do you want to save this value in the database? Or do you want to check calculated value on the login page?

Please give me more detailed description of what you want to achieve.

Hi,

on the list page for the tbl_members I want to show how many "visits" they have left on their account.
The number of visits left is calculated by subtracting number of entries in tbl_visits with their user_ID FROM the number of visits they are allowed to have (tblmembers.visitsAllowed).
I thought it would be simple since the number of visits they have used shows up by the child object link on the list page...
____name__visits allowed__visits remaining

visits(2)John Smith__33____31__

Hi,
edit SQL query on the Edit SQL query tab for this purpose.

Here is a sample:

SELECT tbl_members.name, tbl_members.visitsAllowed-count(tbl_visits_childnumber.FieldName) as `visits remaining`

Hi,

I think what you are saying is that I need to go to the Query section (I'm using 5.1) and then to the SQL tab to edit my initial SQL call. I tried that and got an error that tbl_visits_childnumber does not exist...
here is the SQL call I'm using now...
SELECT

id,

password,

gym_ID,

firstname,

lastname,

address1,

address2,

city,

`state`,

zip,

home_phone,

mobile_phone,

status,

status_comment,

email,

contract_endDate,

`plan`,

gym_membership_id,

contract_startDate,

unlimited,

DATEDIFF(contract_endDate, now()) AS ContractDaysLeft,

DATEDIFF(contract_endDate, contract_startDate) AS ContractLength,

round((DATEDIFF(contract_endDate, contract_startDate)/30)*plan) AS visitAllowed

FROM tbl_members

ORDER BY lastname
by the way, I must say I am always impressed with the number of people you support and the answers you give...

Hi,
this error means that table name is incorrect.

You can publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages and I'll try to help you.