I am trying to use the Instr statement with no success for my VendorCtry field. The following is what i have in the query field for InStr(,). Is this not used...

Hi I've been cutting and pasting address information from web pages into the relevant stakeholders' (SHs) records' address fields (SHs may have multiple...

I have a master list of countries in one table and list of countries with prices in the other table. I am trying to build a query that finds a match for...

I'm using a crosstab query to keep track of employees who are tardy on a daily basis. The times are tracked by the employee undocking and re-docking his...

The field 'Department' should be linked to the value from the field 'Division'. Each Division has many Departments. Both the Division & Department fields are...

Thanks in advance for your responses I am creating one report with several columns that pull data from 3 different tables and are based on different date...

Is there a way to combine 2m or more fields into 1 with an expression such as &" "&&" "& the desired result would be icd9 icd92 icd93

Hi: Can you please tell me how do I change the date format to enter just yyyymm in the parameter in the below qry; now I have to enter...

I am working with a customer database which, unfortunately, contains some duplicate information. Existing customers were sometimes added as new customers. I...

definition in formula: LOS = length of stay (number of days - numeric field) When using the below expression in a calculated field, I get an error message...

Hi, I have a quantity column called 'Qty'. Number values. Quantities range from say... 1 through 5. Multiple records in the table with many different...

I need to have a query pull totals on questions met and not met. I've set up 3 tables PatientInfo, Outcome, Questions patient info table identifies patient...

hello all, I have a table "mytable", from which "date1" holds a date and "label" can contain 2 different text values ( day "one" and "two" ), and a field...

Hello, I am trying to execute a Union query based on two queries. It is giving me an error that says: Expression in Argument 2 has Invalid Value. Here is my...

Hi, Please I need to find in a querry in 1 field multiple parts, e.i in the field there is "Joseph Smith" I want when i search in my querry "Jo Smi" to find...

I have literally been working through this problem in my brain for over a year, and I still have not been able to come to any conclusion (don't ask why I'm...

I am trying to have a Query show the names of people and a date that is 90 dyas before the date that is in the query. More clear explaination- I have a query...

Hi all. I have a query that I am creating to compare volumes to previous day averages. What I am trying to do is have the query prompt me twice for a date...

Your knowledge and help would be very appreciated. I have a db to keep track of projects and their status towards completion. I need to create a summary...

I am running Access 2003 on XP Professional. I need a query to pull records from Now() backwards to a set number of hours such as 12 hours, 24 hours, 48...