Search results

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...

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...

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...

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...

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.

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?

I have an employee table in which one is date of hire. I made a query which contains all the employees date of hire in one column. I now need a new column to which I can add 6 months (PERM DATE) to thier date of hire for perm status. I tried the date add function but could only get it to work...

I'm importing a text file into Access from a SQL program. There are three sets of dates (DATE_HIRED, DATE_PROBATION and DATE_PROMOTION). They are all three formated in SQL to read the same format (ex. 01-NOV-95). The first two import into my table but the third date has a conversion type error...

I have a date in the format of 01-NOV-05. In the criteria how can I get it to add 6 months to that date. Maybe I need to go back to school but can't figure it out for the life of me. Please help.

My employee report is one employee w/info per page. How can I get the whole page to be yellow if, let's say, the guy works for Billing Department. So when I put his employee number in and it brings his record up it will be yellow because he is in Billing. Can I make it so each department has a...

How do I keep repeated data from showing in a report. For example I have: 102 02 Report 02231970 102 02 Reprt2 02231971 102 02 Resend 02231972 How do I get it to look like this: 102 02 Report 02231970 Reprt2 02231971 Resend 02231972 Basically not have the...

Our inventory is based on a number system for example: 101 01 101 02 101 03 102 01 102 02 102 03 102 04 etc What do I have to put in the query to make it skip a space after each group set. For example after 101 and after 102 etc. thanks.