I am trying to do a split of one field into two and put the last two digits of an 11 digit number in field number two. I used the statement below. I also...

Thanks for taking the time to read my question. I have a product list that has an ID for every product. Each product has a name and a size. I have a combo...

Thanks for taking the time to read my question. I have a product list that has an ID for every product. Each product has a name and a size. I have a combo...

Hi, Can you please advise why one of these will work and the other won't. The first does at it should. 1) SELECT ., Sum(.) AS , Avg( /) AS FROM ( INNER JOIN...

Hi, I have a query with the following fields: Date, Part Number, description, etc.. I need a 2 criteria.. 1 for Date and 1 for Part Number and I want them to...

Trying to incorporate 2 left join queries into 1 combined query. Basically I'm trying to get the total REG hours and OVT hours for each pay period and each...

Trying to incorporate 2 left join queries into 1 combined query. Basically I'm trying to get the total REG hours and OVT hours for each pay period and each...

Hi all, I am having an issue getting a query to work in access 2003. I have some linked tables, from an sql 2003 server. I have written the T-SQL statement...

I am teaching myself Access and SQL as I need it on the job, and I want to thank everyone who has contributed to this discussion group for all of your very...

Hello I have a question I hope someone can help me with. The Data Looks like the following: 2 Columns Shares Amount Date RIC 12/29/2006 ...

I have a form with a list box and a combo box that allows me to gather the parameters for my report. They are working fine (w/ the help of this...

Gary Walter was a big help with this problem in 12/06. I have a followup though. I use this code on a form to select 2 parameters for a report. (A Resp....

I have a net amount that is negative and another amount that is negative. I want to know the difference of the two and show that as another amount. Just so...

Is it possible to have 2 nested select queries in a select query? I currently have the following query: SELECT 1.a,2.b,3.c FROM 1,2,3 WHERE 2.b IN (SELECT...

Not quite sure where i should post this, but since i didn't find any "tables discussion group" i ended up at queries. As i am already confused enough i will...

I have a main form (CTAMMain) that has a button to popup another form (CTAContacts), which works fine. But how do I get the data from the query into...

Good Day, I am trying to create a table that will hold my master inventory, however I have two types of orders: Custom and Stock. For my custom orders I would...

Blank I have had a link problem for a long time and can't solve it. When I try to access a link on email I get a window that tells me "IE has encountered a...

Hello, I created an expression in a query in access 2000. RoadBlockHours: /60 I have 2 problems when I run the query. First problem is I get a pop up...

I have a tabel with several fields. 1 field reports open date of a record and another field reports the close time of a record (close time could be blank is...