Search results

I've only just managed to fix a baffling error in one of my database reports after much :banghead:. I thought I would share the very simple solution for anyone else who may encounter similar. Basically, I had a form named 'ReportPage' that acted as a launchpad for a variety of reports. On...

I was driven near demented trying to fix this problem. I tried every solution suggested in this thread (after struggling greatly to follow the first 3 pages...), and this was the one that finally worked. Thank you!

Just those 6 fields capturing the 3 observation periods. No more. There are around 50 or so additional fields holding other information in the database, but nothing else relevant to the observation periods..

The example table I gave in post #7 is an excerpt from my database table. There is an auto number ID field, and then the start and end date fields for 3 observation periods only.

Just the numbering of the field name, i.e. 1st, 2nd, or 3rd.

I'm afraid I'm completely lost now. How would I do this with a crosstab query? To go back to my original post, say for example I had the following: Fields-....ID.....1st Obs Start....1st Obs End.....2nd Obs Start....2nd Obs End.....3rd Obs Start....3rd Obs End...

I could probably do a basic count in a crosstab query, however I've also been asked if I could show additional fields from each record as well, which would only work in a select query. In essence, I'm looking for a way to combine 1st/2nd/3rd Start dates into a single Start dates column, and...

They are distinct fields in a single table, and so the common tie between them would be the ID number (primary key) for the record. Is that what you meant?

I'm not sure that that title truly explains what I'm looking for. For each record in my database, there are observation periods which are recorded in the format dd/mm/yyyy hh:mm:ss, titles as follows 1st Obs Start 1st Obs End 2nd Obs Start 2nd Obs End 3rd Obs Start 3rd Obs End. I have been...

I'm not sure that I quite follow. The forms I have made are based solely on the table. Would I need to create queries from the table and build the forms from them? At the moment, the user can scroll through all records using the forms and simply searches by patient information to find the...

Everything is in the one table. Patient info amounted to about a dozen fields and so I didn't feel it was worth the bother of separating over multiple tables.

Hi all, To briefly explain my database; it is a bespoke referral management system within a hospital. Each record on the database contains patient demographic information, as well as information on their referral (i.e. date of referral, date of assessment, date of commencing treatment...

Fantastic! Thanks for your help, that has solved it. I used "MAX" as a predicate for "SELECT", (ie. Select Max(Dupe.[Discharge Date])) and it has worked perfectly. It would have been helpful for Access Help to have provided an extensive list of predicates rather than just All, Top...

Hi all, I'll first of all explain the purpose of the query. I've built a database to record the admission details of patients admitted to hospital. Amongst other things, the database captures date/time of admission and date/time of discharge. The query I am building needs to show patients...