illingworth22
Registered User.
- Local time
- Today, 07:58
- Joined
- Nov 6, 2009
- Messages
- 17
I have made an Access database which I use for my own recording only. The database logs all the people who pass away in the hospital where I work.
I have a main Register table whith oter tables for wards, consultants ect. Rather than having to use my fingers for calculating the patients age I created a Query and a Form called Age Calculator.
When I go back to my main Register Table and try to add a field Age and then select the query to look up data and click on the Age Calculator query I get the following error
"No valid fileds can be found in 'Age Calculator' You may have to select a query that uses the table your adding the lookup columb to. Please select a new source.
The Query was a simple query, should I have made a cross tab one instead?
Any suggestions?
I have a main Register table whith oter tables for wards, consultants ect. Rather than having to use my fingers for calculating the patients age I created a Query and a Form called Age Calculator.
When I go back to my main Register Table and try to add a field Age and then select the query to look up data and click on the Age Calculator query I get the following error
"No valid fileds can be found in 'Age Calculator' You may have to select a query that uses the table your adding the lookup columb to. Please select a new source.
The Query was a simple query, should I have made a cross tab one instead?
Any suggestions?
