Search results

I was using a query as the source for the query would that make a difference anyway I've just referenced the table and everything works now yet I dont understand why using a query instead of a table would give me different results. Any more ideas need to know like the pic mile u lookin good :eek:

trying still doesnt work, I try 03/01/02-06/11/03 it grabs no 2002 results even though there should be results for that year. Could it be something to do with the fact am grabing the values from forms textboxs as I have tried to see if its incorrect date formating yet it aint I tested to see...

I am trying to grab dates in a certain range inputted by the user on a form and grab from and to date criteria but I try and the dates are acting like numbers, I have tryed to enclose form reference like #[forms].[frmVAT].[txtFrom]# but syntax error. DOnt know what to do. please help I want...

Sorry man am just questioning access I understand what your saying and I think I need to sit down with query builder a bit. Your answer has solved my problem cheers for all the help ;-)

I understand yeah i understand this concept but what if you want to perform no function to a field what do I put into this box I can't put Group By, this will alter my query, I just want to view the field with the rest of the query. ; )

why does why does the query builder automatically select Group By as the aggregate function to be performed, and why can't I just select nothing.

I am yeah I was using a group by on that field but I was also using the By group on other fields, I've got it working now though cheers ; )

Basically I have a query that I've created to sum up multiple fields from a table, the only problem is I have a number field that is a company number that is repeated within my table for other contacts from the same company, that is then picked up by the query. I dont want this to be repeated...

thanks rich you guys are a big help and maybe one day very soon I'll will be able to answer one of your questions.

thanks for your help I just thought it would ave accepted my default local settings, I see it all clearly now thanks for all your help. It was just the fact that one record worked whereas the rest didnt but it was "02/02/11" so I understand. So how could I overcome this date problem? thanks...

I got help yesterday with a problem and got help working it out or so I thought, heres whats happening OK here it is the code, test this and tell me why it won't work it makes no sense. Basically this is executed on a button click from a form and the values serviceno and start are normally...

U R A LEGEND BETTER THAN PAT cheers for all your help it works like a dream.. UR THE MAILMAN ; ) :D until next time ciao ----- Pete -----

to get the example to work you have to press on both the select visible only and turn flag on button then press OK just a very quick example

nice one OK heres an example and I'll tell you what I want basically on the click of the OK button on the frmflag I want the SQL statement to run to find a record with with values predetermined in the code i've set and I want the flag to be set as a tick in the table. with values being set and...

As Jon K suggested it wont work I tried again but it doesn't work so am trying to write an update query to achieve the result. this is what i have so far: DoCmd.RunSQL "UPDATE tables![timesheet header].flag SET flag = -1 WHERE [Timesheet Header]!SERVICE_COMPANY_NO = serviceno And [timesheet...

yeah i thought what your saying might be true but how would I phare an update sql statement for what I what to do am stuck.

OK! this is wot I've got thanks for all your help but look: DoCmd.RunSQL "INSERT INTO [Timesheet Header](flag) VALUES (-1) WHERE [Timesheet Header]!SERVICE_COMPANY_NO = " & Chr(34) & serviceno & Chr(34) And [timesheet header]!PERIOD_STARTING = " & Chr(35) & start & Chr(35);" Run time error...

thanks would it matter if I used a date field start is a date would this make any difference to my statement structure. am still gettin the 3137,"Missing semicolon (;) at end of SQL error I ave no idea.

Here my statement: DoCmd.RunSQL "INSERT INTO [timesheet header](flag) VALUES(-1) WHERE [timesheet header].SERVICE_COMPANY_NO = serviceno AND [timesheet header].PERIOD_STARTING = start; I know the syntax of this querys is probly well off but i have tried so many different ways but can't get it...

YOU R A LEGEND yeah am talkin about you Shadez just as I thought there was no hope, nice all is clear in world Access now, until the next problem this seemed to work a treat: Cal1 = rst.Fields("[C/F]").Value + rst!EELoan - rst!Profit CHeers for all that help Case CLosed ~ SOLVED ~:D