Search results

Hey, i'm not sure if i'm posting this in the right forum, since i'm not sure if I should be trying to solve my problem using a query or a module. I was wondering if anybody knows how to get around this...I have to find the maximum value of each month (May - September) for each person (there...

hello there, I have written a query in access '97 that compares two ID numbers from two separate tables...and if they are equal, i want to copy and paste the phone number, etc into the "originial" from "res_phone" but I keep getting an error that says : "Syntax error (missing operator) in...

Hello :) I'm trying to run my module, but half way into it a pop up comes up saying something along the lines of "MSACCESS.exe has generated errors. and error log is being created. windows will shut down access". i tried using the exact same code on another (smaller) program and it worked...

hello, i've searched through all the posts, but I can't seem to find what i'm looking for. I really need help...here's the situation i have 2 tables table1's first 2 columns are id number column3 is a phonenumber table2's fisrt 2 columns are id numbers, column3-5 are phonenumber, Yes olumn...

hello i'm in desperate need of some help, as it is urgent...i have taken a lot of different approaches to this problem, but nothing seems to be working. here's what i'm trying to do... I am trying to write a module in access in which I am comparing two tables. tabel1 has 2 id numbers in the...

Hey... i'm wondering if anybody could help me with this as it is kind of urgent... does anybody know how to compare a cell value in excel to a field in access? I have to compare each cell in the 2nd column of Excel to the 1st field in access. and if they are equal then copy and paste that...

hello...i'm totally new to all of this and i'm in need of some help i have a table in access that has: 1st column - customer names 2nd column - the date from may1-august31 (some days are missing for certain cutomers) column3 - column26 - data for the 24hrs in 1 day. I was requested to find the...