Search results

Hi AWF crew, hope you are all well. I have this problem with a query. I have 2 tables, a primary table I want to keep complete and a secondary table that has some information I want to add to some of the records in my primary table. When runnig a normal join type query some of the records...

hi maryanne, was a thought I have already had but there is more than one lot of data per property. Approx 4,000,000 / 300,000 = approx 12 - 14 records per property (with that identifier). I suppose I actually want to remove the records that are duplicates now I think about it.

Ken thanks for replying. Not to sure on how to set up a composite primary key, but will google it.

Hi all Just want to confirm i'm on the right track with a very simple query. I have a table with over 4 million records :mad:. It holds historic water consumption data for some 300,000 properties. The fields are as follows: Property ID (integer) To Date (date) From Date (date) KL...

Sensational! datediff() worked a treat. Thanks twoplustwo & MSAccessRookie.

Hi guys I have a query that is calling a Module to find the most recent date out of three in each record. The 3 dates are across 3 fields. PlumberInspection 1Inspection 2Inspection 3textdatedatedate My Query runs to return the most recent date PlumberInspection 1Inspection 2Inspection...

I just figured it out myself. My solution was putting "true" in the criteria.

I have just been given a database for some analysis. It's only 1 table so it should be nice & easy to manipulate. The problem i'm having is filtering a field that is made up of a tick-box form (I'm not sure on the correct technical term for this either). Ideally I should be able to filter out...

I'm still at a bit of a loss as my SQL skills are zero, I have simply cut and paste these commands (Thanks Adam!) into the SQL view of my query, after this i try to save or exit and it spits some tricky jargon at me! Ultimately i would like to group by a certain parameter to find the median...

Hi guys, i am writing a simple query grouping some parameters to find a number of calculations. The 2 i am having trouble with are the median and 90th percentile of my data. I'm sure the median will be easy enough and i'll kick myself once i know.

cool bananas ill give it s hot when i get to work tomoz

I am designing a query it has about 20,000 records with 2 numerical fields(long integer). I want to do a simple division i.e field3:Round([field1]/[field2],2) It works so i assume i have no zero divisors. When i sort field3 Access returns an Overflow message. I've herd this may be because...

Cheers Mike, that worked a treat. I've done that exact command in excel, I should really be more daring in the future and try things like that myself.

GOLD! There's hope for me yet. Cheers Paul.

Hi guys, wow 2nd post already, i'm a veteren! I have a field that is of 'number' datatype. It's nine digits long and am keen to remove the first to 2 characters. i.e 129132450 has to be 9132450 in a completely new feild. I'm thinking some sort of query might be able to to this. I know exactly...

Hi Kids i'm a Newbie so be nice! Only been using Access for a little over 6 months. It's an ongoing struggle but a worthy string to my bow. I have been using a simple join to filter out matching fields from a bigger table that exist in a smaller table. If you like i create the smaller table...