Search results

I spent ages finding out how to add more than one attachment to an auto email, so thuoght i would just post the result here to add to the great knowledge base this forum is, hopefully to be of use to others in te future: As obvious as it seems afterwards, simply duplicate the Set...

hi thanks for the answers guys, we're definately heading in the right direction. ;) I can live with the first couple of days of the year being week 53, but my query returns the next week (ie data for this week we're in now) as week 2... very strange..

hi thanks for the answers guys, we're definately heading in the right direction. ;) I can live with the first couple of days of the year being week 53, but my query returns the next week (ie data for this week we're in now) as week 2... very strange..

Hi Today is 5thJan05. Why does Access think it is week 2? and how can i tell it that it is in fact week 1, which it actually is. I am using this in a query to provide a list of week numbers from a drop down box; the user then selects a week and clicks on whichever report they want to see...

Hi This quote above is my query; why week 53? the last week of the year is 52, but my queries are returning week 53 followed by week 2... any help appreciated, cheers Jez

Jon K - you are a genius! this is the second time i've posted this particular problem and you're the first person to come up with a fix; and it worked first time.. many many thanks...

thanks guys - i'll take a look...

Hi I need some sort of Union Join for 2 query results; What i need (and cant get) is this: I have 2 queries: query 1 user record_set_a fred 5 colin 2 tom 0 paul 3 query 2 user record_set_b fred 3 paul 0 harold 2 tom 4 and the result i need is: user reca recb fred 5 3 colin 2 0...

thanks guys. still cant fix my problem (see other post - just search for References) but hopefully now heading in the right direction..

well i cant. ive been looking everywhere and all i can find is Rich repeatedly writing 'search the archives' 'search the archives' etc for some magic article explaining references. Please provide a link because i have been searching for an hour and can find nothing...

hi Doc, thanks. your reply sounds promising to me, i just got a hunch that its that kind of issue; your analysis sounds spot on. Unfortunately i also have to report that there should be no differences between the machines. i work for quite a large organisation that has an automated desktop...

I cant find that file; is that for XP only? cheers

Could this simply be missing references? Is there an easy way to check for that?

Hi Ok this is going to sound strange but.. One day our Time Recording System was fine. The next day the Access provided Calendar function used in the time recording form shows "Name?" and debug errs out claiming invalid use of period or ! (err 2447 i think). So i reset the references after...

Thanks Pat; i also found UNION in help and had a first crack at the UNION query; i got it to work but it just appended one set of data to the bottom of the next.. So next i'll look at the grouping by and/or removal of duplicates bit... what i have is: query 1 user recorda fred 5...

thaaaank you! thats been driving me mad for... well since i got the job of supporting this DB... Now, just need to understand NULL's and i'm sorted.. cheers Duncan

very very very basic question; When constructing a query you have those fields listed on the left: FIELD, TABLE, SORT, SHOW, CRITERIA etc. How do i make TOTAL appear...?

Thanks Pat; but can i specify a Union All - isn't that exactly my problem...? Where is this 'Union' setting? cheers, Duncan

Enter Parameter Value : HOURSSUM2 all box returned...

=val(Nz([HOURSSUM2 all.Sum Of Hours],0)) Now i get #Error...