Search results

Re: Second go at this. - SOLVED! I did it!! It took about 2 hours tonight to work out the syntax, but I finally got it to work. This is the expression I used to test an input date against 2 sets of From-To conditions and also the seven Weekday fields checked either Yes or No: CallToday...

Here are some images of my tables and query. (Don't laugh if you think I have gone about this totally wrong. That is why I am here!) :o (I don't know why these images are so huge, I have resized them in my file storage??) My tblClients: tblDaysOfWeek: tblClientsCallDays (actually now...

Yes, and it may come to that for some problems. For now I would prefer not to. Although this project is for work, I am doing it mostly in my own time and at my expense. I work for a not-for-profit with limited funding and there isn't much money available for IT projects outside of routine or...

Ok, I'm still needing help on this project. I wish I had someone who I could just call and ask for help! So far I have developed separate queries which will give me a calls list based on today's date that will show calls for any given day of the week. (Actually I have designed 2 queries for...

That is a great alternative to having a checkbox against a record too. It means that you could import an Excel table with a large number of exclusions and be able to deal with them in one action. Nice. :).

Thanks Ranman2656. I guess because I am more of an Excel person I find it hard to think outside multiple fields for things that other table formats will achieve . I'm getting there though.:rolleyes: Can you assist me with the command button question?

Thanks for that Ranman256. I thought of that initially, but the issue is that each client can select any day or days from the week not to receive a call. This means that there either must be a separate field for each day with a Yes/No as a record, or a table with a separate record for each...

Hi all, I asked about this problem in a previous post, and after not receiving any definite solution I got thinking about it further. Previous post link http://www.access-programmers.co.uk/forums/showthread.php?t=279542 added by JDraw My aim is to produce a report daily which shows which...

Ok, here it is: SELECT tblClients.FirstName, tblClients.LastName, tblNoCallDays.NoCallFrom, tblNoCallDays.NoCallTo, tblClients.NoCallDaysMulti.Value, IIf((Date()>=[NoCallFrom] And Date()<=[NoCallTo]) Or [NoCallDaysMulti].[Value]=Weekday(Date(),1),"No","Yes") AS CallToday FROM tblClients LEFT...

Ok, not quite done yet with this issue. Now that I have the query working, I need to filter the results to show only one result for each client. At the moment I have a result for each value in the multivalue field. I can't post links or photos yet but picture several results for each client...

I didn't have to assign the values in the multivalue field. Access correctly worked out the days based on the ID assigned to the days, which are the same as the default values. I did that on purpose just in case the text values didn't work. (The bound column is 1 which is the ID values)...

Hello. Yes, I worked it out. This is the expression I used: CallToday: IIf((Date()>=[NoCallFrom] And Date()<=[NoCallTo]) Or [NoCallDaysMulti].[Value]=Weekday(Date(),2),"No","Yes") I was using an AND operator for the second part and getting the wrong result. Obviously when thinking about it in...

Hello, my name is Steve. I am currently working on a project to develop an access database to help manage a roster of calls to clients on a daily basis based on two general criteria: 1. Pre-determined days selected by the client. (e.g. Call Mon, Wed, Fri only. This can change as client...

Hello all. My name is Steve. I live in Adelaide, Australia where I work as an administration officer for the Australian Red Cross. I have thrown myself in the deep end in regard to a project to try to improve our client data management and daily service delivery for the programs in our Social...