Search results

Hello Everyone, I've been trying to figure out why my query only pulls record Object ID 10011399 and not the other one, but I can't figure it out. Can anyone please help me see what's wrong? Thanks, Pablo

I have a table that mutliple info per Object and I would like to show in one row the old and new information per Object. Basically the row that has an "end date" of 12/31/9999 is the new info and the row with end date different than 12/31/9999 is the old info. I think this can be doen with a...

Hello Everyone, I need help with this unmatching query. I'm trying to unmatch records from two tables, but base on two key fields. I have one table call storage where I accumulate data and the key fields are [Action Date] and [ID]. On my other table "New Data" I also have many records and the...

Hello, I'm importing an excel file that has one column with currency (4 digits after the period) using a macro. When I open the table in Access that was created by the macro the currency column is only 2 digits after the period. Is there a way to import this data without access rounding up the...

Hello Everyone, I'm pulling my hair off with this situation. I have an excel file that was given to us by the payroll department of our company, but my manager doesn't like the layout in which was given to us. I've attached a sample of the file, the file has two sheets the first one is how the...

Hello Everyone, I have an access file (a Form) that I put in the network and it's accessable thru a web site inside our company(intranet). I setup the database to be on shared mode so everyone can access it at the same time. The problem I'm having is that when someone open the file, access...

Hello Everyone, I have a database that I splited the tables on one file and queries, forms and macros in another. The front end file (the one with the forms) I published it in our intranet, so when some one clicks on the link a form pops up which is the way it supposed to work. The problem I...

Hello, I'm trying to get a number of days between an employee's hire date and today's date. The employee is supposed to change levels every year until reaches 6 yrs. The sample employee hired on 11/13/2001 and today's date is 1/13/2006, so it should be only 4 yrs (level 04). I tried assigning...

Hello, I have an unmatched query that I would like to convert to a delete query. I would like to be able to delete the unmatched records from two tables using one query. I tried something like this (below), but I get an error message stating "could not delete from specified tables". What am I...

Hello Everyone, I was given this project and I'm not sure how to start it. I have a table (Employees) that need to receive salary increases based on their level. Their level is calculated based on their time with the company, but some are base on hours worked and some based on days worked. For...

Hello, Is there an easy way to split a full name into firstname, middle name and lastname? I have a field name with names such as James R Lowes and i would like to split the name in 3 like. Firstname : James Middle Initial: R Lastname: Lowes I was able to find a module to extract the first...

Hello, Is there an easy way to split a full name into firstname, middle name and lastname? I have a field name with names such as James R Lowes and i would like to split the name in 3 like. Firstname : James Middle Initial: R Lastname: Lowes I was able to find a module to extract the first...

Hello Everyone, I'm not sure if this is possible. I have a form (link to a table) with option boxes that when I click on one of the option boxes sets a value to a field in the table. The problem is that when I check a different option box I have to manually uncheck the other option box that was...

I need to setup a validation rule to a date field in a form so the date entered must be a Sunday date. I want the system not to accept the date unless is a Sunday date, is there a way to do so? I appreciate any tips on this. thanks, Pablo :confused:

I need help! I'm trying to delete records from Table1 where the field "Name" is equal to the field "Name" in Table2. Please see below what I tried and is not working, any ideas? DELETE table1.* FROM table1 INNER JOIN table2 ON table1.Name = table2.Name; Thanks! :confused:

Does anyone know if there is a way in a report to display an entire row in a different color? I'm running a report based on a query and I need specific information to come up in RED. I read about conditional formatting but you can only apply it to a field in a report, but not to an entire row...

Hi, I need help creating an unmatching query. I've used the wizard before to create an unmatching query to compare two tables and it was working okay until I got a record with a blank value (null). The wizard creates the unmatching query by indicating to pull a value where doesn't exist in one...