Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab Query?
Another approach that keeps the whole thing "live" and updatable: For each application, create an aliased field: Windows: IIf([Application]="Windows","X") XP: IIf ([Application]="XP","X") Then create a report based on the query and include...- mwatrous
- Post #4
- Forum: Microsoft: Access Other topics
-
Missing Records
If your database is on a network, talk to your IT support people. They may have a backup.- mwatrous
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Missing text...
Also make sure your section (detail?) is set to Can Grow.- mwatrous
- Post #7
- Forum: Microsoft: Access Reports
-
Cannot remember - Access Query for grouping
How about a query with aliased fields created like so: Plumbing:IIf([jobtitle]="Plumbing",[name]) Carpentry:IIf([jobtitle]="Carpentry",[name])- mwatrous
- Post #4
- Forum: Microsoft: Access Other topics
-
export report
I don't like the product you get by exporting directly from Access to HTML. Reports export pretty well to rich text format, which you can paste into an HTML editor - but look the resulting text over, as it can do funky things. I've also gone from reports to csv to HTML tables. But just today...- mwatrous
- Post #2
- Forum: Microsoft: Access Other topics
-
Basic Report Generation Question
A slightly different approach: 1. Base your report on a query to select a disc from the table. 2. In your query specify the form and the combo box field as a criterion in the query. For example, if you name your form frmDiscs and the combo box on it DiscName, your query criterion will look...- mwatrous
- Post #4
- Forum: Microsoft: Access Other topics
