Search results

that sounds good... but how do you use this 'microsoft calander control'?

you cant sort, group or filter a report by anything other than the original fields from the query that the report is based on. so that means, you wont be able to set orderBy to the calculated field, unless you calculate the field in the query first, then sort by the query field.

i got it to work, thanks everyone for your help

yes thats exactly what i want to do. thats why i was asking if it was possible to do. i seems it is not, however.

thanks that makes things a lot easier. i had never heard of 'between' before.

Including calculated fields in the WHERE clause I have another question, more out of interest: Can you use the WHERE clause to include calculated fields on the report? For example, if i have a field on the report called text1 and it contains the calculation field: =[cost]*[qty]. In a form...

Marilor - That's exactly what I needed to know. Thanks.

Hi, I was wondering if it is possible to filter the results of a query by selecting one record, then only showing records that preceed it alphabetically. So if you have these names in a database: ALBERT BOB CARLA DILBERT EDWARD FRED And you choose to filter results from CARLA to EDWARD you...

I want to filter a report by vendor. The user types in the name of the vendor in a text box, and then the code does the following: DoCmd.OpenReport stDocName, acPreview, , "[vendorcode] = " & text1 However, I get a prompt for some reason. For example if I enter 'GEORGE' into the text box, when...

Overflow I am getting the overflow error on the following calc in a query: On the clients request, I am to add this calculation to a report. In the query it looks like this x: ([sumofqty]*[cost]) / ([sumofreceived]*[cost]) As the value [sumofreceived] was sometimes zero, I got the division...

I have a form that lets the user select sorting and grouping options for a report. The sorting part was easy. However, I am not sure how to do the grouping. I am guessing I need to create a groupheader in run-time, based on a field the user wants the report to group by. Any ideas?

Yes i have set the orderby property to true what do you mean by having grouping in the report???

i am trying to use the orderby property of a report in microsoft access, but i just doesnt seem to have any effect? i have set order BY on = true in the settings dialog in design mode I have a form which allows the user to select a field by which the report will be ordered by. in code i am...

The main problem is interface... I can get the results, but not in a user-friendly way, and the clients are completely computer illiterate... But I have started coding in Visual Basic and it looks like I can get the results I need that way.

i started using a cross-table query and at first it seemed good. However, I need more grouping options. For example, i can have customer by colour, but i also need to then group the results so that they only show the results for a certain product. So for example, the user choose a product...

actually, both answers worked..

It worked. I hade to change DoCmd.OpenReport "MyReport", acPreview, "", "[Table/QueryName]![Created]>=[Forms]![MyFormName]![MyDateName]" to DoCmd.OpenReport "MyReport", acPreview, "", "[Created]>=[Forms]![MyFormName]![MyDateName]" As it didnt like it for some reason. But that doesnt matter...

Hi. I have a report spec. which requires customers listed from top to bottom, then product colours they have ordered across the top of the page horizontally. then the qty they have ordered should appear lined up with the relevant customer and colour. like a matrix i think? So if customer 1...

Did you figure it out? I am also having a similar problem. I have a report and want to open it via a button on a form like this: DoCmd.OpenReport stDocName, acPreview, , "[created] >= # " & [txtStart] & " #" [created] is a date field in the report [txtStart] is a text box In my case the...

yep it works. thanks