Search results

Hello everyone. I wasn't sure what topic I should post this question under, so I'm posting it here in the General subforum. I'm not even sure if my title accurately conveys my issue (If you can think of a better one, let me know and I'll change it!). I have two tables that are not related...

Hello everyone, I have two tables. One table lists 6 different hospital units and the services that are associated with that unit. The other table is a list of doctors. I want to create a form where a user can select which unit(s) a doctor belongs to and which services within those unit(s)...

Found the answer as soon as I posted this. Like "*" & [Forms].[FormName].[TextBoxName] "*" Sorry to clutter the board.

*Correction, I'm using "Like" in my functions instead of "Alike" as my original posts states. Thanks

Hello all, I have a criteria in a query that references an unbound textbox in a form. Basically, I want to be able to enter a keyword in the textbox, and the query returns all records that contain that keyword in that field. Here's the criteria function I'm using and for some reason it's...

spikepl, Thank you so much! This is exactly what I was looking for! Also, by adding the following: "Event Name" as EVENT to the end of the SQL statements for each select query, I was able to create a new column in the Union Query that identifies the event associated with each date. Thanks...

Hi everyone. I was wondering if you all can tell me if there's a way to accomplish what I'm trying to do: I have a database that contains several projects. Each project has different events associated with it. For the sake of simplicity, let's say each project has the following three events...

Hello everyone, I'm fairly new to Access and I've been racking my brain over this particular issue for a couple of days now, and I was wondering if I could perhaps get some assistance. I have a form (that is sourced to a query) that has 5 date fields. I want to be able to enter a date in...