Hello all, I have created a query that has project details such as the award cost and want to determine the total cost of the project by bringing in the...

I'm trying to summarize some vegetation data that involves putting the trees into categories and classes based on their diameter and their "status" (live...

Hi, I have a contacts database and need to keep it data cleansed to avoid duplicate records. I propose to concatonate all fields into one and would then...

Hi Guys, I have a query with a field call YNDATA(the one that is a check mark), what I want is to create another field in the query that when YNDATA is true,...

Can anyone advise why I am getting a 'Too few parameters - Expected 2' with these two SQL statement? strSQL1 = "UPDATE tbl01_PermSrvcsIgnore, tbl01_Services...

I am trying to use an Iif statement in a query, using a calculated field as one of the result paramets: Exp1: Iif(="9002,,0) is a field in the query being...

Hi all , In my project in Access, i have converted to acess 2003, then I tried to create an MDE but not able to do it. when i tried to create any other...

Hi There - I am trying to create a basic query that excludes certain records. My table has a field that is status. This is a lookup value that I created...

Hello, In a field of a table there are entries with address and city in the same record. For example: High street 55 Paris. I only want the address in that...

I have a form set up for data entry with a subform linking child records in a different table. In the case where a user closes the form halfway through...

I have created 2 separate expressions in query: Test_1: IIf(! Not Like ("**"),"Missing",0) Test_2: IIf(! Not Like ("**"),1, "Found") When I combine them...

I have a two part question as follows: 1st part: I am wanting to create a query that is driven by the user selecting a value from a combo box on a form. the...

I asked this yesterday and see all kinds of questions around me being answered and suppose i just did not word this correctly. I have a table of lab results....

I have a table that looks like the following RUNID | DATETIME | PROCESS 0001 1/1/09 1201 Neck 0001 1/1/09 1202 Neck 0001 ...

Hi All, I have created a query where I can get a count of a specific person's activity. These people log when they recieve mail and when they have actioned...

I am working with several databases that each have 20+ different queries. Most of the queries have the same filter (like 200*)to restrict only the dates...

My company recently changed the vendor codes and now I end up with two separate sets of data for each vendor. Obviously I could just leave the vendor code...

Hi I have a text field whose records contain for 1 to 4 words, separated by space. I am wondering if I can replace automatically only third spaces with...

I have two tables that I want to query. One table contains part numbers and the other usage. The problem is that the usage table can have the base part number...

When pulling data from a table that has multiple parts to a key, how does Access determine which criteria statement to read...