Search results

Cracked it with Dsum Pat, I have got round the problem with a Dsum back to the source table but using the combo selections for the sum field and criteria as follows: =DSum("[" & [Forms]![Form1]![Combo0] & "]","Sourcedata","[BUCC]=" & "'" & [Forms]![Form1]![Combo32] & "'") Please don't tell me...

Running Sum on Unbound Text Box Thanks for the reply Pat but I am none the clearer? What I have is a user select front end of a financial budget plan. The user selects four years from 4 combo boxes. Then when the form button is pressed the VBA on the on open is as follows: Text13.ControlSource...

I have a form that is generated from combo box selections. In the detail section of this form the text boxes are unbound but obviously controlled from the combo selection. I want to sum these text boxes in the footer of the form. I have put in the footer: =Sum([Textx]) and when the form opens I...

Fratezone, Thanks for the reply, but I am a little surprised att he response. Does this also apply to forms? For example if the user selected a number of field names from a combo box within a form. Could you not use those combo box selections as field names for another form? e.g. use the same...

No I don't want to add any criteria in the query. I want the user to select fields for the query to run. The combo box or list box bit is easy. Then when the user hits the query button, the selected fields from the combo boxes gets transfered into the field boxes in the query design grid. The...

Sorry for the errors within my post, deadlines, headache, frustration etc. Heeellllllppp!

Jon, I just want to use a form to select the fields which the query uses to examine the table? The query then lists all records for the selcted fields? I hope I am not just being dim? Can this be done? I have search the whole forum with no luck, looked at the query be form samples. However...

I asked a question related to this yesterday with no luck. So I will ask a simple question: Can a query be designed so from choices the user makes in a form made up of combo boxes with field lists. The query then outputs the results of those field selections? I have tried putting in the field...

Correct me if I am wrong but do I do this by creating a form with combo boxes listing the foeld names? But then how do I link that to a query? I want the user to select the fields in order to create another form that they can then edit? Cheers J:o

I don't think I am being clear enough. I have a table with field names such as 2002 2003 2004 etc. Each field then contains financial data. I want the query to ask the user to select a year or a range of years (field names) and then the query list all the data from those fields. Every time I...

This is probably going to be very simple? I have written a query etc etc. All I want to do is within the query make the user select a year e.g. Expr1: [Select Year] The query then selects the inputed year from the table field names and displays all the data from that year. Every time I try this...

Rich, I have changed the table data as: Supplier Year Spend Created a crosstab query, and that work ok. What I want to do is then create a report in which the user selects the year span to report from i.e. from 2001 to 1997. I created a parameter query limked to the crosstab and access would...

Hayley, Thanks for the response and I do need a little extra help. My table is as follows with the top row as the Year field names (column field names)and the suppliers as the other row headings as follows: 2002 2001 2000 Supplier x £3000 £2000 £1000 Supplier y...

Thanks Scott for your reply but that doesn't help. My table the query refers is linked to an excel spreadsheet. The left hand column is a list of suppliers. The top row is years. The data is spend of supplier in that year: 2002 2001 2000 Supplier Name 300,000...

Help please. All I want to do is on a query prompt the user to select the year field. I have a number of year fields containing spend(£) data. I have tried a number of expresions in the field entry grid with no success.

Please forgive me as I think this may be obvious but I am a Jnr member, and a real Access headache! I have a linked table to an Excel spreadsheet. The table shows suppliers in row and years in column. The data consists of spend £. All I want to do is run a query to count the spend for that year...