Recent content by loddiemonster

The value that will always be the same is the Customer ID for each person that has a license. The lic_id is different. I wish I could add a status field, but our database would not allow that. Several people update the database each day with license information, and I’m trying to create a...

Thanks for responding! I don’t think that will work. Provisional End Date and Full License End Date is in the same field. I tried running a Union Query with query one showing only provisional licenses and query two showing full licenses, and they’re still overlapping. Consumer ID 100 had a...

I hope this isn’t too confusing: I’m trying to create a query that will pull one of two options for one customer ID. My fields are: ID, lic_id (license ID) and exp_date. In this particular situation, it is possible for one customer ID to have two lic_id entered into my database. If that is...

I created a table that lists 10 services that we offer. The table contains the following fields: Service ID, Service, Client ID, Hours per week. In design view, under the Lookup tab, for display view, I set it at Combo Box Drop Down because one client can have up to three services they can...

Thanks for responding Myrtle! The database I have created tracks clients receiving a specialized service. When a new client is entered, there are one of four different letters that is required to mail to them. The form identifies the type letter, so I wrote my query to prompt me to enter the...

I'm new to the forum, but I've been utilizing this website to help with projects. I am "self-taught" in Access, so my knowledge of VBA is minimal at best. I am creating a database. I have all my forms, queries, tables, reports just as I need them. However, I would like to have a command...