Search results

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?

When I am sending information from access in email I put a command button on the switchboard and attached a 'sendobject' macro to it. When you set up the macro in the 'Action Arguments' box at the bottom of the screen you set the 'Output Format' to 'Rich Text Format (*rtf)'. Hope this helps :-)

I am trying to run a report that has a list of fund names on it and the detail is broken down to a very low level. However, when reporting this information the management team only wants to it on a high level. So what I want to do is this. For instance if Sarah, John, Marlene and Richard are...

The 'Yes' 'No' in the field is automatically generated by a IIf function and isn't selected by a user.

I have a text box on my form that is behaving strangely. It is set up as a text box and is driven by an IIf statement. When the answer is autmatically input into the field it says either yes or no just as I want it to but........... when the cursor clicks on it it turns into a number and any...

I am trying to produce a report that shows names as a row heading and numerous categories as the column headings, no problem....yet. I am also trying to get the query to total in each row the amount of items for each category were over due. I alsready have a field in the form that calculates...