REPORT DISPLAYING SINGLE VALUE (1 Viewer)

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Good morning I have uploaded DB in full it my first real stab at anything but wouldnt be anywhere near with out the amazing help here.. Well aware I perhaps need to review WIKI to help sort tables etc not the best reader though...

My question is my report which is labelled A4CDM when displying a record

1. medication only displays 1 record although have two in table related to this ID
2. this is the same for observations and NEWS2
3. In the care log the last column should be initials but gives a number

They may be simple errors or more undelying complex any help appreciated

1602658256783.png
1602658272011.png
 

Attachments

  • CDM1R211bTAB33111.accdb
    2.3 MB · Views: 101

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:45
Joined
May 7, 2009
Messages
19,169
you need to create sub-reports for those.
 

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Arh ok suppose I should have relised,,

Would that also sort initials
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:45
Joined
May 7, 2009
Messages
19,169
here is your report with subReports.
 

Attachments

  • CDM1R211bTAB33111.zip
    421.1 KB · Views: 104

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
@arnelgp many thanks for your kind help, I have added meds seems to work.. Would you be able to look at why the forms repeat continuously and why I cannot get initals to work on care log
 

Attachments

  • aCDM1R211bTAB33111.accdb
    3 MB · Views: 113

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:45
Joined
May 7, 2009
Messages
19,169
check the recordsouce of the report.
i also added a useful function.
 

Attachments

  • aCDM1R211bTAB33111.zip
    397.2 KB · Views: 106

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Good morning very helpful thankyou really taking shape appreciate all the help

Will work on the initial bit it has to be sourcing or something
 

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Urgggg think I messed that up probally should have created a query first as wanted the report to based on surname selected... WHich I have tryed to work out today
 

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
As the main report is basic I assume I need to change one of the fields for example Surname prompt for input,,, would this then reset all the sub forms to that set of records or do I have to reset everything

Many thanks for any help in advance
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:45
Joined
May 7, 2009
Messages
19,169
create a Form that has a combobox where you can select a patient to print.
see A4CDM report.
 

Attachments

  • aCDM1R211bTAB33111.zip
    413.9 KB · Views: 111

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Amazing, thankyou I must be searching the the wrong questions, or just beyond my thought pattern

Its really facinating
 

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Hi I thought all was working but entering a new recored brings up sam in fo even though I have added new record,, Im a creating an error
 

dubiousp

Member
Local time
Today, 09:45
Joined
Mar 6, 2020
Messages
86
Good afternoon I have tried to read through to see why the record does not change,, could you offer any advice many thanks in advance
 

Attachments

  • aCDM1R211bTAB331111.accdb
    2.9 MB · Views: 99

Users who are viewing this thread

Top Bottom