Recent content by sxu-mic

I've seen a couple of references to examples of certain features in the solutions database. Where can I get this database? I'm trying to use calender controls for user input parameters to run a report and I am having lots of trouble.

try this: field Phone Number Group by field Number of Minutes Sum

Depending on how you want to trigger the action, you can use a macro.

Just curious: Why would you want to store the calculated results in a table and not another query?

I have a report that is run when user enters a month. I would like for the user to choose from a list. I used [Corresponding Month] = Forms![FormCombo]![Combo], where FormCombo is the form name and Combo is the combo list box. When I run the query it just prompts me for...

Hi, Is this what you want? Bring up all records in TableA that contains a [DocID] that's not in TableB. If so, you first need to link the [DocID] field in both tables, creating a join to include all records from TableA and only records in TableB where values are equal. Then select the...

Toyotagirlsee my edited post above, i added something

What are you grouping by? For example: I. Year Month Date Sum will give you sum per date II. Year Month Sum will give you sum per month III. Year Sum will give you sum per year I'm not sure I'm interpreting this correctly, but if you're trying to add 525 and 620 you...

In July 2002 we're looking at data from July 2001 to July 2002. So the report for July 2002 already include info from 2001. Therefore, the report itself is only for the current year. That is why I don't ask for year.

No prob re the misunderstanding. Ooh, ooh, now you have me really excited. I originally did want to use a drop-down menu for input value. Can you use a drop down menu for user-input values in a report? I mean, I am certain you can, I was just afraid it's too complicated. If it's not too...

My bad. The field name I used is actually [Corresponding Month]. I thought saying [Month] would make it easier but I guess it just confuses people. :) Newman I am not sure I understand you, so let me clarify myself first. When running a report, I want the user to input a month in alpha...

similar prob I have a similar problem. I am trying to retrieve reports by month. The query the report is based on have the months stored in numeric format. How can the user input either "Jan" or "January" and have the query retrieve values of [Month]=1 (Where [Month] is the field containing...