Thanks for the reply. You were correct about the query. I changed something on the original query instead of the copy of I made. I guess I should apologize to the Access gods for blaming them. Thanks for your help!
I'm experiencing problems with one of my reports. Whenever I run it, no data appears. However, when I run the query that I used to create the report, the data appears in the query. Does anyone know any reason why Access would torment me like this?
I just figured it out, and it is easier than you could possibly imagine. All you have to do is go to the Page Setup function. In the columns tab, all you have to do is set it to 2,3 or however many columsn you want on one page!
I'm creating a report for a photo directory. I want employee pictures to print in a report format. I set up the report with my fields from my query, and when I run the report, every record prints in a column, but it only prints one column per page. To conserve space & paper, I would like two...
Leslie,
The table that I am dealing with is my main table. I have several other tables that I used as foreign keys in the main table, so there are a lot of integral relationships set up.
Basically, the table looks something like this:
exitinterviewID(primary key)
AgeID(foreignkey)...
Let me take this one step further. Perhaps I am going about this all wrong...
First, I pulled all of my fields from my table into a query and listed "like 4" in the criteria. I was able to extract all of the responses that selected "4", but now how do I create that into a...
It's been awhile since I've worked with Access, and I'm totally blanking on how to create this query. I created a db to track our exit interview responses. There are several questions where employees are asked to rate their experiences on a scale of 1-4. How can I write a query to determine...
I'm not sure if this can even be done or maybe it is extremely simple and I missed something fundamental, but here goes...
I have a db with my main table and several other tables with information that I use as foreign keys in the main table. For example, my "gender" table has 3...
Still somewhat of an Access novice. I am looking to purchase 1-2 good Access manuals, but there are so many choices out there. Any suggestions are greatly appreciated.
Regards
I am trying to create an option box/toggle box in a form that will allow me to choose more than one option. FOr example, the question on the form is "Please check all that apply." How do I make a box that allows someone to check more than one option? Any suggestions would be greatly...
I am trying to create an option box/toggle box in a form that will allow me to choose more than one option. FOr example, the question on the form is "Please check all that apply." How do I make a box that allows someone to check more than one option? Any suggestions would be greatly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.