Search results

tehNellie- NULL Question Is there somewhere in the Query Design view where I can say if there is a NULL make it a zero. John's way did bring up more rows but I noticed if column 1 is null and column 2 says 2 then the row doesn't show. Here's what I'm trying to do: Table:Column 1 UIC(Dept)...

I have to add the row data in two columns together. I used val([COLUMN 1])+val([COLUMN 2]) and it works unless one of the columns has a zero in it. For example if column 1 is 25 and column 2 is NULL it runs the query but puts a #ERROR in those rows. Please help.

I give up. I can't get it to work. I have two tables, one is employee address and I have a table called City/ZIP. The city/zip table contains all the cities in Indiana with only the zip codes that apply to that city. I have found errors in the employees address table that have a wrong zip to the...

I have two columns, one is number needed and the other is number stocked. How can I get the number stocked column to subrtract from the number needed column. I need to have it done in query. Those are also the title of the columns. Thanks.

I trying to take a SQLPLUS script and put it into Access. Got a mojority of it to work great but am having trouble with decode some vacancy jobs codes to words. How would you translate this for Access: decode(a.allowed - nvl(a.assigned,'0'),'-1','EXCESS - 1','-2','EXCESS - 2')). Allowed is how...

That did it. Thanks. I'm learning.

I have to run a seniority query but have an issue. I have job descriptions but can't put them in ASC order because they wouldn't be by seniority. For example: Docker Docker supervisor Dock Chief Shift Supervisor Section Leader In SQL I would do a decode function and assign each a number and...

I keep getting a Data Type Mismatch in the criteria expression. Any suggestions?

This is probably an easy criteria but I'm getting close to COB and I have to have it in today. I have a DOB as (DD Mon YY 04 Jul 79) in which I need to create a column for thier age. Then I have to show all the people who are over 60 years old. I can't even get thier age to show correct. Any...

I have two separate columns in my query but they contain the same kind of data. These two columns data should match but some of the data doesn't. Can I write a criteria that will show me only the rows that do not match. DUTY POSC 11B1 11B1 11B1 11B1 11C1 11B1 11B1 11B1 92Y1 11B1 11B1...

If I have a date column and another column with another consistant date, Can I make a criteria to compare one to the other. Ex: END_DATE Today's_DATE 06 Feb 05 15 Jun 06 12 Feb 05 15 Jun 06 01 Jan 06...

I've moved tons of text files or Excel files into Access DB's but I need to take an ODBC report and put it into a table on a new Access DB. If I save the report as a text file I get boxes when I import it to the new DB. If I use Excel I have to make a new table each time. Can anyone suggest the...

THanks. It worked.

Ok I"m a new to Access, so bare with me. I have a report: DATE TRANS ALR ASG_LOSS_DESC 20060508 DSCH SC SELECTIVE OR QUALITATIVE 20060508 DSCH SC SELECTIVE OR QUALITATIVE 20060508 DSCH SC SELECTIVE OR QUALITATIVE 20060508 DSCH SC SELECTIVE OR QUALITATIVE 20060508...

YES. I'm trying to find all the E5 SGT who have an MOS not in the 2 skill level. So I need to run it so it'll search for All the skill levels except 2. For example I have a list of SGT and thier 3 mos and want to search those mos for anything but skill level 2 mos. I've tried RIGHT([POSC],1)...

If I have a field, let's say "Job Skill", and they are a 5 digit code, like 46R2. I need to find all the 46R codes except the 2's(last digit). I'm trying to write a mismatch report that will show all the skill level 2 who are in the wrong skill level job like (1 or 3's). Any help is appreciated.

How, Ken? Is it a DateAdd script?

I have a field called DATE_END_DEERS which is in a format of YYYYMMDD (20060530). I need to run a query that shows 6 months subtracted from this date. I can never get an answer that is even close. Can someone please help? ACCESS2000.

My table doesn't show duplicate records but when I run a query off theat table every single record has a duplicate record. What did I do wrong or how can I fix this?

New error Thanks, Rich When I do like you said I now get a Data type mismatch in criteria expression.