Search results

That helped a lot Thanks so much! That helped a lot and I was able to finish my forms, queries and reports in less than an hour. As for the name in both places, it wasn't necessary to have it that way, I was just trying to find something in common to make them relate to one another. I got...

I have two tables: TABLE A( name, week begin, week end, company) and TABLE B(name, date, expense, description, amount). I have tried to create a form/subform, but am having trouble. Form (table A), Subform (table B). I'm trying to create a one-to-many expense report where the person types in...

Did you try grouping your report on the Program ID? Then when you select Program ID under grouping/sorting, you can choose to have a group header and footer. List the Program Name under the Group Header and use your counting in the Program Footer. I don't know if it will help with the whole...

Ok, color me stupid. Could you show me an example? Here is my expression =DCount("[Product desc]","PC Inventory-Master","[Product desc]='Atlanta'"). PC Inventory is the database. Product desc (either Monitor, Laptop, Desktop). Location is either Atlanta, Chicago, Houston. I am not familiar...

I have a report based on a PC Inventory table. The table contains 3 locations (ex. Chicago, Houston, Atlanta). Within each location, the employees are listed with their desktop info, Monitor info, laptop info. My report is grouped by location. What I am trying to do is count how many...

I have a query based report that needs to show the sales rep name who prospected the account, but I need to limit the characters that show up. The field looks like this "Doe, John(Atlanta 1061)". I have tried to do a simple =left([SalesRep],10), but I keep getting errors. Can someone explain...