| Thread | Last Post | Replies |
|
| Export Format Defaults | 16 Sep 2005 18:43 GMT | 4 |
I would like to change the default export format from Comma delimited, No Headers, and quotes to Tab Delimited, Headers and No Quotes. Any ideas? TIA,
|
| testing my outlookexpress | 16 Sep 2005 18:14 GMT | 1 |
I'm testing my outlook express, learning how to use news groups. thanks.
|
| Change Sorting in a Report | 16 Sep 2005 18:03 GMT | 5 |
I have a report that is sorted by Month, and it is sorting alphabetically, how do I get it to sort by month starting with January? I have sorted it by month in the table and it starts with January, but for some reason when I do the report it is sorting alphabetically. Please ...
|
| ControlSource Field Not Calculating Correctly | 16 Sep 2005 17:49 GMT | 1 |
I have a query that counts the number of dept-ids. I’m using this query in a report. How can I multiply the count field by $50? On the control source field, I’m using: =Sum([CountOfDept ID]*50) but it’s giving me the wrong results. For instance if the count is “1” the
|
| DCount with mathematical criteria, DateDiff function | 16 Sep 2005 17:34 GMT | 2 |
I am trying to make a count of records meeting criteria for demographic groups in a report. One section includes age brackets. I can get everything to work using the DCount function in text boxes, but when I try mathematical criteria, such as:
|
| 2nd REQUEST - Inventory Levels | 16 Sep 2005 16:30 GMT | 5 |
Please help - I think this dropped off the radar because I couldn't look at it for a week. Here is the original post and replies. Thanks! - I could not get solution to work Thanks John, I have been on another project so I wasn't able to revisit
|
| Error "The expression On Print..." | 16 Sep 2005 16:23 GMT | 3 |
I have a report that I am accessing by pushing a button on a form. When I try to move to the second page, I get the following message: The expression On Print you entered as the event property setting produced the following error:
|
| Report to group by model numbers with a count per locaton | 16 Sep 2005 16:19 GMT | 4 |
I need to create a report that has 40 columns. The first one is a list of model numbers and the other 39 need to show a count (how many) at each of our store locations based on the condition of a status of "N" (new). The table I am pulling the data from has Model, Store nbr, ...
|
| How to create multi-page reports in Access? | 16 Sep 2005 15:56 GMT | 1 |
I have to create a 10 page contract. I started to prepare the contract in "Reports", however, it will not allow me to move the page down any further to add more of the verbage. Is there another way to do this--maybe exporting to Word. Any suggestions would be appreciated.
|
| access open report where condition | 16 Sep 2005 15:53 GMT | 1 |
In VBA I'm trying to write an docmd openreport routine where the "wherecondition" is entered by the user. Has anyone every written something like this and what is the proper syntax? I have successfully used this procedure where the condition is hard coded by never a variable.
|
| Combobox into a report | 16 Sep 2005 15:10 GMT | 4 |
I keep getting Syntax error(missing operator) in query expression '(And [Skil1] = 'name')' Dim qrystring As String Dim fieldresult As String
|
| Pie charts | 16 Sep 2005 14:44 GMT | 6 |
I would like to add a pie chart to a report and have it change with each record to reflect just that records information. I have tried to do this, but cannot seem to get it to work. I can only get all information or just one 'piece' of the pie. Any suggestions?
|
| Report Query | 16 Sep 2005 14:29 GMT | 1 |
I have a database that has 4 fields. It has an incident number, an agency, the sex of an individual, and the section an individual belongs in. I am trying to create a report that gives me the number of individuals in an agency and the number of male and female indivduals in a ...
|
| Force New Page for Detail Section not working in XP | 16 Sep 2005 09:39 GMT | 2 |
I have a report which has various sections: Rpt hdr, Pg hdr, Grp hdr (contains controls but has visible set false), Detail (record source for report returns only one row, but detail section contains several subreports) and Pg ftr. I have set the Force New Page property of the ...
|
| Using a Drop Down Box for User Input/Parameter | 16 Sep 2005 05:56 GMT | 3 |
I have a report based on a query. When the report runs, I want the user to be able to pick the type of building from a list of 5 types. The types are listed in another table. How do I incoporate a drop down/combo box into the parameter for the report/query?
|