Dear all I have 2 Tbl's one Called Search_Tlb & Documents_Settings_Tbl with the same fields In the tbls I have a field called FolderPath, with these...

Hi I have a client table. User provides four keywords and I need to select clients whose names contain any two of the given keywords. How do I go about...

Hi I am trying to find the best way to find unmatched data. I have tried this below and found a few but not all unmatched data, still having...

I made a query for an invoice. It has several tables in it. One of the tables is the items that the customer purchased, and one is how they paid. The...

Hi I have two tables with two columns each. Each table has an id column and a value column. I would like the two tables to be merged so there are three...

I am trying to find the average days between orders and shipments for 2001, grouped by employee. Every time I put the fields in it asks for ship date and order...

I am trying to set up a query/report for exam due dates. So, for instance, individuals should have a dental exam every 6 months. I would like to run a...

Hi I need to run a saved query and just need to know if there are any records returned. Not interested in actual records. What is the easiest way to do...

I have a simple expression query that I just can not get. I have a table called discs, in this table there is a logical field (yes,no) called clubs. I want to...

I had a question about a count query. I have parent records (literally about parents) that include a date when the parent came in for the first appt. Based on...

Has anyone else tried MS Access (2003 or 2007) with Vista RTM? I have Macro that lets a series of 130 or so queries that churn thru a large database (280k...

I have a text field. How can I find records with only alphabetic characters in it? Thanks

I need to calculate a field in query which uses two values in two fields (field1, field2) to run a query, then sum and average all the values in two other...

I have the following expression GGWPERSQFT: IIf(IsNull(),/,/) but I want to add: if is zero, then null otherwise IIf(IsNull(),/,/)

I am trying to run a query on expirations of certifications of employees. My query runs and checks 7 dates to see if they are expiring within the next 30...

Hi! When we run a query, display title: Enter Parameter Value Is it possible to change this title? Thanks in advance. an

Just curious -- why is it that when I sum up check boxes on a record, the value in the query is Yes/No (even though I can click on the value and see the...

Greetings. I am building a query to return all records between dates selected by the user. When I use the following code to build my query, the date...

Can I make something like this: column1 - column 2 but only for some grouped variables For example: Substract Debt - Payment for each client in NYC, then in...