Search results

I'm not entirely sure how to summarize this quickly and correctly in the Title box, since I'm not sure where the solution lies as yet...ultimately, all I need to do is get a number and it's associated location name passed to a report headers. So here's my problem: I have inherited an Access...

I'm using Access 2010, and have been having an issue with report filters. I'm creating some flexible reports that let the user filter by year or location, then the next time they can apply different filters, that kind of thing. The problem is that some of these filters seem to be sticking. I do...

I have a meeting database...one table has individual meeting information, a second has information on the meeting series...so all the meetings are part of an annual series, one table tracks the meetings, the other has higher-level meeting series info. The meeting series table has a field for...

I'm working in Access 2010, and used a crosstab query to make a pivotchart. It's a pretty simple bar chart. The question is that now that I've made this chart, how do I use it? I can't seem to figure out how to put it into a report...I made a report based on the crosstab query data, but it...

I'm hoping that writing this out will help me figure out how to do this. I'm setting up a database in Access 2010. One field is a list of outside companies that assist on a particular project (the main data item is a project...project number, name, date, budget, then company). I can do this...

I'm importing data from Excel 2010 to Access 2010. The data is fine, except that for one field in particular, there are about 9-15 spaces at the end of the data (which is city names). This will become a problem, because I need to concatenate the city name with the country name at some point...

I run an expression in a query (in Access 2010) that divides two fields (Let's say 'FieldX' and 'FieldY') to get a percentage. Sometimes the data is not present, resulting in a #Num because it's dividing by 0, which is fine, but my question is...how do I replace the #Num with something like a...