Hi, The following query gives me a Run-time error '3146' ODBC call failed. I've tested each select statement individually, and the queires work. If I run...

Hello Everyone- I am having problems figuring out how to use concatenate. I read and tried to use Duane Hookum's sample but I'm afraid I continue to get...

Is there a way to have a query parameter give the user a combo box of the available choices. I want the user to pick a name from a list instead of typing it...

Can anyone help me figure out why this nested IIf statement is stopping after the first two conditions? I have a total of 5 conditions I need to add to it. ...

Hi. An extract of my data table looks as so: SYMBOL Code AA AE AA ae AAPL AB ABT A2 ACE 7G

Hello, I am trying to create a query from an appended table to take only the max days from the same S/O# and Oper#, but does not know what to do. Here is the...

Hi, is there a way to add proceeding zeros to zip code text field that is less than 5 characters? I want a way to add the zeros to the field to make the...

Hello, I wasn't sure which group in Access to post this to, so I'm starting here... My user would like to take her data in the table below and have it...

Hi This is my first attempt at using access and I am presented with the following situation. I have a table called Trades with a field for each record...

I am trying to create the following "if statement" in MS access through Expression...

ocity dcity consignee ship date Total Price Total ships week no memphis oasis NAM1 2/21/2008 333 memphis oasis NAM1 2/20/2008 3333 mumbai cinci1 ...

I have 2 sub tables that are both foreign key related to a main table. I need to move to fields from one table (t1) and move it into the other (t2). I need...

Hi, I have the following data: CSPC Exp date B0893 11/19/2009 B0893 11/19/2010 B0894 10/20/2009

Hi hope you can help, I have an orders table which contains order number and due date, I want a query to return all records from the oldest date to 4 weeks...

I generate the numeric values that I want in a cross tab query but cannot get it to change the values to percentages in relationship to totals in that view. ...

I have a query with a field call month. In this field there are different months of the year. I'm trying to pull serveral reports using more than on form. Is...

I have a button on a form which opens a query in datasheet view. I would like to click on a record and have a predesigned report open about that record. ...

I have a function to calculate a score, which is used in my query. It looks at a percentage, and returns a 1-10 score based on the percentage returned. The...

I want to build a query based upon user chosen fields. The following condition will pull all accounts with "credit scores" greater than or equal to the...

This is sort of both a queries and a forms question. I have a query in Access 2003 that relies on two tables and another query (we'll call it "the subquery")....