Search results

Does anyone know of anywhere that I may be able to get hold of some button designs for use in A2K? I have tried the usual graphics with a transparent button on top, but they still dont look professional. Any hints and tips would be greatly appreciated. Thanks in advance, Barry.

Hi there, You could try this very simple solution. I dont know what sort of front-end you have set up, but why dont you try opening the report from an unbound form? You will need 2 unbound text boxes on your form: [start date] and [end date]. Set your parameters in your query to target these...

Hello again, I have finally solved the problem, for anyone that is interested. Thank you again for all of your help on this problem, before I asked on this site I thought I was the only one who didnt know about crosstabs and was starting to think I was thick!!!!! To solve the problem what I...

Try working out this in your footer: =Avg([GradeGrade]) call it "overall average" then work out the total weight =Sum([weight]) call it "total weight" Then in another texbox try this: =Sum([overall average]*[total weight]/100*100) I think that may give you what you are after, but...

Hi there Richie, The Criteria are all row headings, and the form does stay open when the button is pressed. This is why it is so annoying. To give you a bit more info, the crosstab takes it "values" from an attendance table and counts how many times a student has been 1. Present, 2.Sick...

Are you setting the borders of the report in design view? (by borders I am presuming that you are talking about margins) If I am right then the margins will save in design veiw but not in print preview! I hope this has helped (if I understood you correctly) Barry.

Hello, I am having a major pain in the a**e with a crosstab report as well, so my sympathy goes out to you, but I cant see why the right join isnt displaying all of the "times" and showing data for only those times that are filled! Hey Ho, the joys of crosstabs eh? Great when they do what you...

I think, if I have understood you correctly, what you need to do is this: In the group footer, you will need to set the control scource of a text box to this: =Sum(Avg([GradeGrade])*[weight]/100*100) You will then get the overall sum of your field. I hope this is what you needed and my...

Hi again, I have tried this solution, and I am still getting the same Error: Does not recognise <field name> as a valid field or expression. Thank you for the suggestion, and for aminute i thought it was actually going to work. Anyway, thanks again, the search continues ...

Hello access guru's, Does anyone have the answer to my query I posted yesterday: Crosstab Report - linking from an unbound form. I am sorry if I am being impatient, but this has been annoying me for 3 days now, and I cant get the code right at all. I keep getting the same error. If only they...

Hi there, I think what you need to do is this. Create a table with all of the times you require. I think you said every 1/2 hour from 8am to 6pm. You will then need to make up a query for your crosstab using a right join from your "times" table to the table which contains your data. This means...

Hello, me again. I feel I should add that the unbound form that I mentioned is a "Print Menu" for the report. It is essential that users be able to view/print this report by certain catagories/filters. I have thought of opening up the querydef and using a case select for this, but as there are...

Hi there, I have a report based on a crosstab query, which lists students attendance figures. There are aprox 2800 students listed in the query. The problem I am having is that I cant seem to set a linkcriteria from an unbound field on a form to filter the data on the report. Every student has...