Recent content by mtc67

thanks i appriciate it especially seeing i can't get hold of the original designer.

I have followed your suggestions and played with them to see if i could get the results desired but it did not happen. The variations I have tried are: 1)Between [Forms]![Dtes]![StartDate]! And [Forms]![Dtes]![EndDate]! result: error message about there being too may bang operators 2)Between...

hi I was just about to pass in my database when my supervisor decided to rearrange the way data is gathered. originally he wanted to manually type in if the volunteer was new or returning ( a yes/no field) now he want the computer to add the values for him and place them into the report. I did...

rich; i'm still a bit confused about your solution...I am not following some of your directions (i have a problem with that sometimes)...so here goes please explain: 1) by datsourse i assume you mean recordsource 2)where do I add the dae field- to the report or the query? 3)how do you open the...

hi I am using the calander control and this code links the calender to the text boxes...I'm not sure if it is what you are looking for though... Private Sub cmdSetDates_Click() On Error GoTo cmdSetDates_Error If...

Please be patient I will let you know if your suggestion worked for me hopefully today. I kind of had a mishap and stupidly overwrote my new database with my old one instead of visa-versa. Luckily I do have documentation and can replace all new things fairly quickly. I look forward to...

i was hoping to be able to use the existing system and modify it... how would i go about doing the monthly totals query? The difficulty i am having with the totals is that across the top the want the clubs (of which there are aprox 15) and down the sides the member types ( again about...

could i take the crosstab and put it in a sub report while refering on the main report to the date... I am probably thinking of what you can do with a form and sub form and this may not even be acceptable for this type of report. I may just redesign the whole thing and use calculations to...

Thanks, I'll give it a try and let you know if I fool it up to badly... I only have another hour here today but will attempt it in the morning. But in the meantime other suggestions would be welcome...just in case [This message has been edited by mtc67 (edited 06-28-2001).]

yes it is the field called sign up date i have tried to add that to the crosstab query but my results seem fooled up i also put the date in using the criteria as the calender control results but an error message came up

i'm sorry when i first asked the question I did not state myself clearly enough. Each month the user prints a report of all member numbers and their different associations within the organization. It is not based on a date but on all records available. The query is based on the members table...

I was just re-looking at the system and the report is coming from a crosstab query. I have never created one of those but have a general idea of how they work. The problem now is that in the crosstab there is no mention of a date...I tried adding it and it gave a result of each entry with the...

Thanks a lot. The solution worked great! Your help worked again.

i have now another question about the same report... I want to have a sum of only the new members hours and i want to add up the old members hours as well. I have tried a query and it tells me that I cannot. I put my fields in and tried to get the sum of new members by also adding: field...

thanks everyone... changing the format from a yes/no worked! I was not aware of it being important. Thanks to everyone who helped a struggling but stubborn student out.