Search results

Peeps, please don't give each other stress, we are all here to help each other - or in my case, get help from you lovely contributors. Myself and others learn so much from all of you, seriously, I am awed by the expertise. It is interesting to compare different approaches for us relative...

June, yeah, we actually need the listing of all annual dates, it is tedious but needed. But thank you :)

@ebs17, you are a genius!! And very generous, thank you so much :)

Major brain fog here and hope someone can help. I need to generate "annual report due dates" between two dates. Reports start 1 year after RECApprovalDate and continue yearly until ProjectEndDate. I have the below and it is currently producing a single date 1 year after the REC date per project...

Yeah, I suppose I haven't explained the database schema my question. The first query pulls records from tblProjects, qryPeople and a link table that connects the two. qryPeople is a query to combine people's first, middle and last names into one column (using a function to format it properly)...

I think I may have resolved this. I had the source of the search box query as a copy of Query 2, instead of using it as source and making it into a SELECT type query rather than aggregated. It seems to be working now. Thank you all for reading and comments (keeping that code in my library of...

@ebs17 regarding the queries, yes, me too. I tried many things to concatenate names into a row per project and this was the only thing that worked to get one ProjectID and group the people in concatenated format into one row just for the purpose of displaying them in a listbox. Not sure how else...

Hi there, Long-time user of these forums (previously fluffyozzy). I am stuck with something and hoping someone can point me in the right direction. I have a listbox with a number of fields and a search box on a form. I have done this before and always worked but this time it is not working and...