Search results

Hey there, well I'm having an issue trying to get a report to show a single customers' data on one report. The way I am doing it at the minute isn't really a way I would like to do it, using a query to create the report, but I don't know how to do it via a form. Basically when I do it at the...

Thanks CJ, you're a life saver :) And I have no idea whether it is supposed to do that or not, all I care about is that it works. This is just for a section of ICT coursework, and I don't need to implement it. So just as long as it works, then I am happy :P

Sorry for the late reply. The problem is on the "Customer/Server details" form The problem with it is that it is impossible to add new data in any field

I don't have a GROUP BY... I thought the Totals query was the "=[number of months]*[Cost]" but I had to look online what a GROUP BY was, as I didn't know what to remove, and I don't have one :/ I'm sure sometimes databases just decide they don't want to work -_-

The only thing I found in that link that MAY be the issue is: "It has a GROUP BY clause. A Totals query is always read-only." Now the only reason I say that is because I have a text box with "=[text44]*[Cost]" which works out the total cost of everything on that page... but it also needs to be...

Hey there, sorry if this has been asked and answered a million times before. But I had only found one "solution" online, and I didn't understand it at all :/ So anyway, the issue. I can't enter data into either a main form or the sub-form in it. Before you ask are the allow edits, etc...

Hey there, I am having an issue when trying to print a report from a form. Well to put it simply, I am trying to have it so when I press the print report button (or macro, etc.) it will show a report that has the information that was onscreen in the form. At the minute it will print off every...

Yes it is an Auto Number field, and I am trying to get it to display the latest number in that field

I don't know :/ I tried both of the expressions and neither worked. Unless I am a complete idiot, here is what I did/have: I have a few fields in a query, one being ServerID In the criteria I put Max(ServerID) - Which it changed to Max([ServerID]) But that didn't work So I put in DMax, but I...

Hey guys, this probably has a simple solution but I have no idea how to fix it :( What I want to do is have a macro run a query (which I have no issue on doing) but then have the query display the result from the latest record. -If that made no sense: I have a query which has multiple fields...