Recent content by Chineham

The field I am using to search in does not appear on the graph. But there is one query attached to the form that contains the criteria information for the prompt and there is the other query that powers the graph. Could this have something to do with it? Have you tried putting in a dummy...

Nope, doesn't work. It's really weird I do this kind of thing all the time, but, now that there is a graph in the form it won't work. It's got something to do with the graph for definite. Anymore ideas? [This message has been edited by Chineham (edited 04-23-2002).]

I'll have a go. Cheers Sarah

Go to your Query and type Between [Enter start date:] and [Enter end date:] in the criteria row for the field you want access to search. This one always works for me! Let me know :-)

I have managed to do this before where I have a form running from a query that has a prompt in the criteria such...[Enter start date:].by using an unbound text box and entering [Enter start date:] as the 'control source' the date input is automatically updated in the header. But... and there is...

On my report that I am designing I want the report to total by group, not all the records on the report. My report is set out like this:~ Task Job Number Fund Name I want to know the total amount of records under the fund name for each task. All the records are grouped by 'Task'...

I see your point. Would it be possible to have an example? :-)

Can you explain a bit more or maybe a lot more!

Sorted!!

In the properties field under the 'Visible' field is it set to 'Yes'?

I've just found a really simple way of doing it!! Use the ' Fund Duplicates Query' from the Query Wizard and away you go. Easy as 1, 2, 3!

I've tried that but I'm getting an error message of:~ Compile Error: Expected: expression and highlights the ' character. Can you help?

Thanks for your help, I'm gonna see if it works. The information that will input daily is from a combo box, so that is the 'same information daily'. I need it to realise that it is not a duplicates when looking at the table, because, obviously this information will be duplicated over and over...

Is it possible for a database to recognise that duplicate has been input on a specific date? For example, my database has the same information input onto one particular field daily, however, the other fields do change. Want I want to know is if a user goes in and enters the details more than...

Can somebody please explain to me the ABS function, how it works and how it should be used?