Search results

This is nearly a match to a thread i posted on friday - with just a little more info: I'm making *another (different - I swear!) report so that the department can print labels (name & address). The label dimensions are 99.1mm * 38.1mm. I have no problem in the data downwards, i.e: add1...

Who can save my life and become my biggest hero!?!?!?!?! I'm making a report so that the department can print labels (name & address). The label dimensions are 99.1mm * 38.1mm. I have no problem in the data downwards, i.e: add1 add2 add3 ... But i'd like to print them like this: add1...

seems to work if i set all the fields to Min. Thanks a lot guys

you mean in the totals box? I tried that, also tried first. Neither seems to work...

One More Thing... Oh I just remembered about the 'DateAdd("m", 6, [YourDate])' function, so the only thing I really need is taking the 1st pass date entered out of the three please, Ta, Lee

I need to set up a query that works out an assessment expiration date: Students take 3 assessments in no particular order. Once they have passed their first assessment, the date of the pass is noted. Also, they have 2 years from that date to complete the other 2 assessments - or it all gets...

how do i get rid of the next, previuos, first last arrows at the bottom of the form (or subform in this instance)? Ta, Lee

I have a 2 page report - but its now 3 because a blank page comes in between the pages. I thought it was a margin problem - like you get in word, so have played around with them but still get the blank one. Its now getting very frustrating - even though its only a cosmetic thing. Can anyone...

I'm using DCount to get statistics within my report. One of the fields ( [TCSecuredBeforeEnroll] ) in a table making up a query has a yes/no format, and is edited by selecting a checkbox in a form. I've used the following to try and recognise it but it comes up with #error...

ta very much. how i got a job doing access i'll never understand!

sounds goo, where's the hide duplicates thing??

I'm trying to get a report done but am stuck because i get the 'your report goes over the margins/boundaries etc etc' message. I'm putting all the data in the footer because i only want it to appear 1nce. I tried a page break but that doesnt work (maybe cos it's in the footer) and now I'm...

Thanks a lot. Should've searched in the first place hey!? The only thing is, i can only see DateDiff functions that use Date() . I would like to use a static date: 04/09/2003 - so how would I use that instead??

ah, its numeric, as in 2002, 1999, etc etc...

Hi, I need t calculate how many people <21, between 21 & 25, and >25. The format of the dates I have is dd/mm/yyyy So how do I calculate the ages?? P.S - I know its a stupid quiestion - I'm struggling abit today :confused:

Hi there. I'm doing a report for university stats. So I'm using alot of DCount in the textfields. It was all going smoothlly until i had an error whilst using the following: =DCount("[StatusCode]","stu-stats","[MOQInstituteName] = 'Cardiff' AND [StatusCode] ='R ' AND [MOQType] ='Law Degree'...

so it does. How do I sort it?

my query links 2 tables. Student Data, and Students-means_of_qualifying: My query runs a list of the students enrolled at university-along with their qualifying degrees. The list is a little long, because if a student has > 1 degree, it adds that as well, and i only want the 1 record by...

thats a strange one. I put it in the footer and it still didnt work. So i put it back, and it did!!! Oh well, thanks anyways!!

But why doesnt this work? Its in the control source field of a report: =DCount("[YearOfEntry]","Stu-StudentData"," [YearOfEntry] = '2003' ") and comes out with an error on the report. While i'm here, how do i get it to come out once, rather than for every student??