Search results

If you can’t normalize (are you sure?). When you build your query and add each field to the grid, you can then add new names in front of the field names from the table in the format: New_name: Old_name You can then use the ‘new_name’ as a variable in your Expressions. Using 1, 2, 3, 4, etc...

Would this work: In your query add 1: Name-of-Field 2: Name-of-Field ... 206: Name-of-Field, to customize the names for each field. Then your Aggregate function can be Expr1: 1+2+3+4+5 ... +206. No limits passed with this. Ginny

Hi all, I would very much appreciate help with this one. So thanks in advance if anyone can help. I have a table which has a Text Field (it has to be, I'm afraid). The data is listed as follows: 5.6% 12.23% 2.45% etc. I need to use these values to multiply other figures in...

I'll have a go, and see if I can find more info on it. Thanks for the suggestion. rgs Ginny

Hi Uncle Gizmo, Can you tell me how to do this? I'm using Access 2000, but have access to Access 2002 also. thanks Ginny

I have listboxes on my report, which are pulling multiple rows of data from queries. I need to export this data to Word or Excel. Can anyone point me to where I can learn what I need to do to achieve this? All the rest of the data on my Reports get exported but not the data in the listboxes...

Hi Craig, I prepare the data in Excel so I will stick with this option. I was hoping that I could take this step out of my process. I have 7 report outputs from another system, these end up in 4 tables in my Access Database, but the fields don't correspond in all of the reports, hence needing...

Ok, that appears to be the only way to do it. Thanks for that. rgs Ginny

I was afraid they might be my only options!! Thanks to both of you. appreciated. I won't waste any more time trying so... rgs Ginny

I have a table which I need to import from Excel into Access, but I only want to import the first character from each cell of one of the columns. Is this possible? rgs Ginny

I looked again and I realised that on the Text box there is the option of changing the format and working with Decimals, but I can't find the same options with List Boxes. Screen attached. Ginny

adding number format Hi Bob, I have opened the report in Design view. I have a number of list box controls + labels, a couple of textboxes. I can't see any reference to STANDARD on the format tab in Properties for any of the items selected. I've attached what is available on the properties...

Hi again, I have looked for the "decimal property of the field controls" in the Design View of my Report. It's not there, I'm afraid. I'm working in Access 2000. I have checked the Report, Detail and List Box Properties. There are no options for changing number formats. I thought maybe it...

Thanks Ajetrumpet, will try again.

Thanks Pat, I've a lot to learn ! ! Yes, 'jumping through hoops' I have my data in a new table for each new month. I'll now work on getting this data into an existing table using update. I'm not feeling confident enough to try using DAO (Access 2000 I'm afraid) yet. Ginny

Hi all, I have a number of list boxes outputting data in my reports. The underlying queries have all number formats set to Standard, 0 decimal points. I have done this using the properties box in the queries. The report is outputting the data with 2 decimal points. Is there an easy way to...

If you requery the form after update on the combo box this should update the second. I had a similar problem earlier today, and it worked for me. Give it a go. HTH Ginny

Yes, I'm aware of that, but in this case, we want to run current month report from this database, but for a certain number of fields we are holding values to show a trend. This is an interim solution until something better is developed. Hence the departure from good practice! Thanks for your...

Hi Bob, it looks like I'm stuck. I have a query returning a single calculated value from 2 underlying tables. (I can output a second field which would have a text name which can be used as a criteria.) I now want to store this value in a table without creating a new table or appending it. Is...

Thanks for the quick response, I'll read up ! ! Ginny