Search results

You must be absolutely right. I need now to r4structure my database. I have two separate tables for details of consultants and SPRs. But now I need to have one with identifier. I will need to think how they will appear in combo boxes separately but that would be easy I believe. Many thanks

It came to my mind though to create a different table for absentees. Set several fields like Cons_abs_1, Cons_abs_2, Cons_abs_3, Cons_abs_4 and SPR_abs_1, SPR_abs_2, SPR_abs_3 and so on up to theoretically possible number of absentees on one day. And then have just one record for each day. In...

Unfortunately I cant create a single table for both Consultants and SPRs absences. Because every absence is registered as a separate record. I need to keep consultants and SPRs in separate tables as they have different pattern of other activities.

If it's impossible to do it via query, then I've got to try to create one table out of two tables. I don't remember why I decided to register them separately, Maybe because I used concatenate function for both both to have a string of people absent on the same day. But I hope I will sort it...

Potentially can.

I think its not exactly what I want. Concatenate function I understand when you want to stitch values from several records into one string. What I need is to show in my query records for all dates, not only for those which have related date in the second table. So If I have in table 1 five...

I am sorry I tried to set spaces between fields but when I posted all spaces where contracted. I meant not one long string but three different fields for Date_abs, Cons_abs and SPR_abs.

Hi I am back with my bizarre questions. What I want now is to create a query which would include fields from two Tables. The problem is as follows. Table 1 has fields: Date_abs as date; Cons_abs as string It returns datasheet: 06/01/2019 LS, NC, AW am, EK 07/01/2019 TW, CK, AW am, EK...

Thanks MickJav Where can I find how to loop and create temporary tables?

The thing is some reports are from cross tab queries. Some are from simple queries. Activities are not similar. Some of the activities required me to use Concatrelated function to get a string of multiple entries. So it's quite complicated.

So, I need to create an empty report and put all my reports into that container as supports? Where should I put them, into the details section? And your suggestion of outputting data to excel by automation looks an idea for me. I have never done it as I though it's too complex for my brain. But...

Yes I tried sub reports. But they don't stitch nicely as I need. I need in the end report something like the excel worksheet which I posted here https://www.access-programmers.co.uk/forums/showthread.php?t=308581

Hi I am developing a departmental rota database. I posted a few questions in other places. Now I have a question regarding reports. I am going to have several reports. Unfortunately I can't see a way to create one report because some reports require cross tab queries and some are not. I need in...

It works as well So I solved this problem. Now I am facing another more difficult problem. I need to stitch several reports into one. How do I do that? Is it possible at all. I need that all reports were stitched nicely and the row for each date should go in continuity from one report to...

Thanks This is probably a good function, but how can I use it not in SQL but as a function in expression builder?

The first parameter worked for some dates but left blank for other dates. The second parameter worked perfectly, exactly what I wanted. Many thanks Gasman!

Yes it was my mistake it should be 11/01\20 of course And yes I am trying to use that function but I can't get what I want. I can't understand how to set the 3rd argument in the function to define filter. If I dont set this argument then it returns all entries of consultants for all dates.

I keep truing to built my dream departmental rota database. I have achieved something. No I need to do a trick. I have a query with the name q_r_11_cons_abs It shows consultants absent for each day: Date abs Cons_abs_gull_am_pm 10/01/2020 NC 10/01/2020 CK 10/01/2020 SM 11/01/2020 CK am...

I attached two spreadsheets which have been used by my predecessor

That will be the most difficult task as I will have to incorporate at least three separate reports into one report. That will be a real challenge for me.