Thanks Jim it works to a point, some of the records sets it pulls out are correct, but some of the time it shows the same set of records for a number of different dates. So i think i will give up on this as the data base probably need re-designing, so make do with the reports i can all ready get out such as a from to date of lowest readings and a from to date report of the average of the 4 readings for each date.
Thank you again it has...
kadavu
Last Activity: Dec 8 '10, 10:32 AM
Joined: Apr 17 '10
Location: NSW Australia
-
Jim i saw the icon to insert an image but it wants the image to be in an url and when i change that to a folder on my computer it just puts the following.
"""" without the quotes.
So i will try to explain what i am doing.
4 readings are taken each time and the table "tblReadingDate Time" and a form "frmReadingDate Time" is linked to it, it being the main form, shown in form view.
"tblReading s"...Leave a comment:
-
Jim I would like to show you a picture of the forms in question, but i do not know how to include a picture in this system.
BrianLeave a comment:
-
Printing a Report with multiple Primary key entries in 1 row
I have a database with just 2 tables
Table 1 "tblReadingDate Time"
ID Indexed Auto Number and primary key
Date Date/Time
Time Date/Time
Systolic Number (Single)
Diastolic Number (Single)
Pulse Number (Single)
Comment Text
Table 2 "tblReading s"
ID Indexed Auto Number and primary key
Date Date/Time
Time ... -
Thank you NeoPa that works and is more elegant than my solution.
Brian...Leave a comment:
-
SOLVED:- The trick is
Date_Time:Forma t[Date]&"_"&[Time],"dd/mm/yy"&"_"&"hh:mm" )Leave a comment:
-
Format a joined date time field in a query
Table has a date field formatted as a short date dd/mm/yy, and a time field formatted as short time hh:nn. When I join those fields in a query
ie. Date_Time:[Date]&"_"&[Time] the result is displayed as dd/mm/yyyy_hh:nn:ss in the query and the chart that is attached to it. I only want dd/mm/yy_hh:nn to be displayed.
How can i change it. I have tried to format the joined field, and either and the query does not run...
No activity results to display
Leave a comment: