Search results

hey, wot would i enter in my criteria box in my date field if i wanted to bring up a box which asked u for a start date and an end date and then displayed the data between those dates. please help cheers rob

Could you please tell me how do i group in forms? thanx rob

that doesnt make any sense? i am getting todays data but if i run the report 5 times sometimes say all the records will be correct and then the next 4 times they will be wrong or using the record from the previous. Its just not queying the query correctly i think i just dont know how to get...

can i create a button that will make it go from one record to the next and requery on every click? i relaise access has its own built in buttons but i want to use my own please help

i right click on the button go to properties and there is no " on click" all the data and events tabs are blank im confussed?

Hey there im having trouble with my graph that when i run my report with my graph on the graph does not update to the data in the query. i would like to put a comman button in to update the graph to see if that works please help i have no idea how to do this. cheers rob p.s i am using access97

hey i think i now how to fix ur problem. right click on the graphs in design view and go to properties. check that the master and child link fields are the same these are the fields which link the data on the report to the graph, then in the row source above click anywhere in that box and at...

Hey there, i have recently put together a report with a graph in which shows the cumulative increase of some data. Now i know my underying querie contains all the correct data, and every day a new date is added with that days data which is all correct. However my problem is that when i run my...

i can calculate the total how im doing it is i have query which sums up all the counts for that vehicle to date, however i need to work out that for example the counts on the 17th was say 10 and say on the 18th its 5 so on the graph it would show for the 17th 10 counts an for the 18th it would...

I have contract number as one field this is the vehicles number. i then have a date field next to it (dd/mm/yy format) and number of changes count field next to that.everyday the table gets appended with new data. this table then is used in another query so i can group by vehicle number and it...

Hi there, at the moment i have a graph in access which works out the number of changes made to a certain vehicle in that day for example. Monday - 5 tuesday -6 wednesday - 4 and so on However this graph only shows the day to day changes i would like it to work out the total number of changes to...

PLEASE HELP!

Hi i am trying to run a report from some data in a query which is collected from a other tables and queries. In the report i have a graph which is based on the data in the query. When i run the report i get the error message "Cannot use the crosstab of a non-fixed column as a sub query. if i...

I am looking for help in trimming off some characters from a field name, say the last 3 characters. i wonderd if there was fucntion built into access which would enable me to do this in a query. any help is appeciated thanks rob

Hey there here is what im trying to do that i need help with. I want to check my stock code field check the 2nd from last character, IF it equals a / then remove last 2 characters, else remove last 3. Can anybody help me with this code and where i will put it? thanx rob

Hey there here is what im trying to do that i need help with. I want to check my stock code field check the 2nd from last character, IF it equals a / then remove last 2 characters, else remove last 3. Can anybody help me with this code and where i will put it? thanx rob

i appreciate ur help i cannot however send u the database as it is over 500MB in size as it is my companys database. I have spoken to someone who does a lot of work in vba and i have been told that rtf files wont import into access due to the formating around them and access doesnt like it, he...

would that be able to run an automated process where by it selects all files say every morning in that folder and isert them all into a table? and would there then be a way of getting the data out of the that file into a field? the file type is a . rtf i know thats lot to help with but...

hey i have installed the link u gave me but it still wont let me use it and still bring up the same error message any more idea or is there any other way to get round to sloving my origional problem, and wot does this microsoft tool do? cheers rob

hey do u have a hotmail account i can talk to u over msn? rob