Hi All, I've got 2 fields in my database that represent Easting and Northings. Due to the way the client's db is set up, I need to append each of these...

I am using Access 2003 A couple of years ago, I created a query to append employee files from my active Db to a Retiree Db. I need to do this again and want...

I am trying to do an update query on 07-09 A2 from 07-09 A. Both are date fields on tables. The only problem is there may be 2 or 3 records that have been...

I know this is simple to do, but can’t seem to do it correctly!! I have a “final_status� variable field that contains values such as “active�...

I have a table with a field called FUND (Range from 1 to 10,000) and another called Class_Type, which is Null. Weekly, the data is deleted and replaced with...

I have a crosstab query where the dates are the column headings. What is the best way to group them by month? I found a Microsoft article talking about how to...

I have a Timestamp field. It contains the date and time. I need a date range. Between and works but this field has a time stamp after the date. Like & "*"...

I'm working on a database that contains information about how well a question was scored on an internal assessment. In order to make the data work for...

I am having a problem with a query i have written and was wondering if anybody can help tell me why. If I do not put the end where statment (Where...

Trying run an Update query to update table values with value(s) from a joined Query. I've tried the usual JOIN options and the following is my latest...

In the design grid I have created a total line that has several group bys and firsts. I get the data I need but the column headings now say firstof and then...

I have a problem that I hope can be fixed by one of two solutions. On a Form, I have a "Keywords" field for labeling items being entered into a database. Some...

I am trying to figure out how to allow a user to update many other records based on data that was just entered on the current record. Here is the...

i want to be able to pull up info from a certian company. Haw do i code it to search for this company. My previous criteria wsa which meant that you had to...

Hai,to every one here is my question I have designed the coding to collect the feedback report from the user, which includes Name of the user, staffno and...

Hi. I think this may be impossible but I will ask anyway! I have created a function that evaluates 2 values from fields in a query. The function passes a...

Hi, I have the following: SELECT .Communes, ., ., (nz()-nz())/(nz()+nz()) AS Percentage FROM ORDER BY .Communes;

I am trying to create an update query that when the AcctNo in G1Table = the AcctNo in FacilityTable (which here it is the primary key), then I want the...

Hi all, I have a query when you run it then it will pop up a little screen asking to enter begining date and ending date. I was wondering if I can set a mask...

I have a table with some duplicate records I want to delete automatically. I found this on line help...