Search results

Thank you both - this works great :)

I have two tables. One with the following: Table 1: ID Date ABC 1/1/2015 Table 2: ID Date: ABC 12/1/2104 ABC 1/3/2015 ABC 1/3/2016 Result I'm looking for: Table 1: ID Date: Table__Date: ABC 1/1/2015 1/3/2015 In this example, I need to pull in...

Hi, I am trying to run a query that does the following: I want to bring in only the three characters to the right of a number field from a table. So if it is 35.25, I want it to bring in .25 The problem is when I try to bring in something like 30.90, it brings it in as 0.9 because it is not...

Hi, I am trying to sort a table I have in access. However, every time I sort, I keep getting an error saying "type mismatch in expression" -- What does this mean? It's not allowing me to sort any field. Thanks in advance, P

thank you for your help : )

Hi, I have created a form what allows you to enter how many hours an employee has worked a week. There is a column for Reg hours, OT hours, and DT hours. Is there a way (maybe by a command button using a query) where if I type in 48 hours in REG , it will automatically put 8 as OT and 40 as reg...

Hi, I am trying to append records a query in a table. but I keep recieving the error "can't append all the records in the append query" due to validation rules. What does this mean and how do I resolve this? Thank you

Hi, I have a form. There is a background image in the form. I am trying to change it the image but when I do, the old buttons and labels don't come through to the new background image. I know this is very simple but can't figure it out. help, Thanks, P.

If I have a query and I have a form linked to it, when I run the query and it asks me for the parameter, is there a way I can list more than one for example, branch at a time branch at a time? (the "enter Parameter Value" box) Thanks, P.

Hi, I have a query that runs most of the time but once in awhile I receive this error message- "This expresion is typed incorrectly, or it too complicated to be evaluated.For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning...

Hi, I have file that is importing social security numbers to access. It is coming in aas a text.However dropping a zero if it has a zero in front of it - for example "012345678" is coming through as "12345678". Is there a way I can update the socials with the zeroes in front? Thanks in...

Thank you soo much:o

Hi, I have a database that I have put on the network where I will be having over 50 people updating data to. And yes I overlooked the fact that if one user has it open, it will show up as read only for another and they are not able to save their data. Is there any way around this? Thanks in...

Hi, I'm trying to create a form that does the following: I have a table that has a date, and branch number and 4 fields that are empty. I would like to have a form that has a drop down of the branch and date. How do I populate the other 4 fields in the table through the form? Ideally I would...

Hi, I'm trying to run a query as such: I have a table with socials that are entered multiple times because that's the number of days worked and then sometimes the social is entered once cause the employee started working the last day of the pay period for examplethis is how the table looks...

Hi, I have one bill table and one vendor table. Both tables have the common field "vendor name". I want to retrieve all the rows from the bill table that have the same vendor name in the vendor table. When I try to join the two tables,I am not getting all the info from the bill table. I can't...

Thank you very much for this. It worked

Hi, I have a table with employee ID#'s in it. I am trying to run a query that: if the same emp ID is listed more than 3 times, i want it to return the information for that employee. Is there a way to do this? Thanks in advance, P.

Hi, i am running a query that matches two tables by social security numbers. The import file I am bringing in, some of the socials should have a zero in front but they don't. For example, the file is bringing it in as 12345678 instead of 012345678. Because of that, some of socials are not...

I know I'm late, but thank you, this worked