Search results

oh, sorry the field is effective_date from change_order_requester. regarding normalizing, this database is mostely imports from excel therefore, this is the best i was able to do. thanks. give me any suggestions!

here is a sample copy, look at the query that i need to work on. I need to group by maxium call_date and change_type:= remove. thanks.

thanks, this is a start, but the problem is that the PK is different for each record, the only thing that is common is the computer_serial_num, i'm trying to group by computer_serial with call_date = max but not luck still!!!

hi all, I have a question hoping that someone can provide assistance. I have a huge table that consist of almost 10,000 records. The three columns that I need to look at are as follows: computer_serial, change_type, call_date. change_type can be: add, move, remove i need to show all records...

I have a table that has almost 10,000 records. The table is an imported one from excel. The main two columns are: printer_serial_num and call_date call date column is the date customers called for trouble shooting. how can i write a query to give me all printers that have mulitple or more...

WayneRyan you are the best.

I have a column that consist of sentence, how do i parse the first word only, for example LP200 ag, 500, how do i cut LP200 and replace it in a new column. Thanks.

Ok, i have been trying to get help with no success, I deleted the orignal post incase I didn't explain it right, ok i'm going to try to get help with the first section. i have a table that has 5000 rows, it consists of serial number (not primary) at the end of the table i created a colum for...

I have an access table for computer support, the table has computer name, call date and ect.... I want to create a report to show me all computers that have been called more than once with a call date range for five days, for example if computer A has been called three times with a week I want...

thanks Sir, you're good.

I have a query that looks like this, datediff("d",[end_date],[start_date])/30 it's working perfect, but it's give me a decimal number, how can I formate it to get rid of the decimals, if I put "m" instead of the "d" than this number won't be accurate, can someone help? thanks.

I just fiqured that out, this is so so wired, the problem is that I had the module name in the module name properties same as the module real name! when I changed the module name in teh module properties to a different one it worked!!! can someone please explain, because I'm pulling my hair out...

The way i did it is by creating a new module and then pasting the whole thing in it. Is that right?

Undefined function guys please, can someone help? I'm using this function and it's not working, I put it in a query, but I keep getting a message undefined function !!!!!!

I have a table that I imported from excel. It has start date, start time, end date end date. I did the datediff function to get the number of hours took, for exampel I wanted a report to show if the start and end date took more than 24 hours, but the problem is that I have some dates that...

got it thanks!!!!!!!!!!!!!!!!1

This is very tricky I hope that someone can help please. I have a table that I imported to access, it has four columns, start date start time finish date finish time. I need to generate a report to show items that took more than 30 hrs, ontop of this items that fall within friday have a...

I wrote a long sql in a form, I have a button, I want to click on the button and have the sql run the subform. so basically i'm trying to make the sql in vba run for a subform. can someone help me please.

Thanks Mhartman, that's what i was looking for.

Does anyone know where I can get a list of vb color codes, I had a table long time ago but I lost the file. It had the displayed color and it's vb code. Thanks in advance.