Help please. Would like to take Expr2: Now() - Value Value would be 6 for six months. Like the result written in regular Date Time. Thanks, Tony

A query was running using a linked table to an Access database. The query linked an access table from the current database and uptated that table with data...

Hello, I am more accustomed to Oracle.... am still thinking in terms of Oracle... Please help me with this issue. I am trying to compare two tables A and...

Below is Access SQL for review... SELECT PublishingDetailsHistory.AgreementID, PublishingDetailsHistory.SubjectMatter FROM PublishingDetailsHistory WHERE...

hello to all This is a general question about nesting one SQL in another. The example is just made up to help me understand. Start with 2 queries called...

¥þ³¡¦³«O¾i,¹q62893103 ¯S»ùGame,$50°_

Hi! I want to create a query that will lookup the value from another table. my first table contains the amount(field) and the other table contains...

Why is my new database read only after closing it for the first time? I cannot find any settings which show default of read only? Thank you.

Hi, Have imported a file as text and have a field call From_Date and has come in as text as 38833 what function do I use in access to change it to an access...

When I was making a simple query I´ve got this message "internal OLE automation error" and I don't know why. Can anyone help me please? Thanks

I want to group data so that I can see the total risk applicable to a merchant ID and name of merchant. The names of the same merchant are recorded in...

Due to the new format of the input text file, I modified the import specification of my tool. I basically deleted a column named RECORD. Thus, the new import...

Hi, I have a table with two columns where the value may have changed and may not have changed - for example Group 5 to Group 10. I want to query so that I...

I need a query that will give me a value of 1 for each record that is not null in any one of twenty fields (text datatype). In other words, I need to search...

Hi, i have to insert values into two tables in one transaction. The first table (base table) has a primary key (type 'integer') which is incremented...

I posted this yesterday , got one post for additional infor, posted update, and then nothing. I would like to try again since I really do need to get this...

I really need someone’s help. I have two tables, one has employee’s allowances and the other has their basic pay. I need to calculate their gross. The...

Hello - I have extracted a number from a string and would like to sort on this value as if it were a number. In my query I have created a field as...

Is there a way to calculate group totals in a query. I want to sum up the value of several items per box #. -- Lynette

I have a table with an item field that can consist of an item #, a sub assembly item #, and sub-sub assembly item # separated by periods. I need to break...