Recent content by Poindexter

I am sorry, I think I may have explained it wrong. I am able to reduce it to only the routes I want by having it reference a table with the selected routes as you suggest. The problem is that if one of those routes does not appear in one of the tables with ridership than that route does not...

Thanks, that seemed to work I think I was missing the table.

I tried that, however it says teh expression has invalid syntax. Any other ideas?

I would like to run a query that will report the ridership on certain bus routes in a single day. I have tables with the boardings and alightings for all buses under various situations. However, not all of the bus routes that I am interested in are present is in each situation (table). So when I...

I am fairly new to Access, so I am sure there is a fairly easy way to do this but I just can not figure it out. I have data in three tables. Data at different time frames and table that what is being measured. I have run a query that sums all of the data that is being measured by the table it...

I am fairly new to access, I have built a form for data entry and tables, which the form is bound to a master table and references various table as options the user can select. The form is being used to record evaluations of various documents for consistencies with other policies. As we have...

I am using a form to enter data into Table 1. The form has various combo boxes that allow the user to select infromation from a list, contained in Table 2. However, when I look at Table 1 I noticed that the ID field from Table 2 is appearing in the field where I expected the information I...

Thanks, I think I have it working now.

Do I need to start over?

The data tab is blank.

I can not find the "record source". I tried setting the control source to the field I want it linked to in the table but it does not let me enter data or select items from the combo box once the link is created. Any thoughts as to what I am doing wrong or where I can find record source?

I have created a form and a table for data entery purposes. However, all of the text boxes, combo boxse, and toggle switch in the form are unbound. How do I bound them to a particular column in the table? Or, am better off creating a new form that is bound? If so how do you establish this link?

To be honest I had not created a table earlier. But I have now created one, however I am not sure what the appropriate data type is for information that will be provided from a toggle switch. Also, what I am looking for to make sure the controls are bound to the respective table fields. I am...

I am fairly new to access and have never created data entry Forms in Access. But so far I have created a Form with multiple combo boxes referencing various tables, text boxes for individuals information, and toggle switches for characteristic of the individuals. The Form was created for data...