Search results

  1. O

    numerical sort

    Ive changed the Date field to Con_Date and instead of using Format i used DatePart and it works a treat, cheers guys
  2. O

    numerical sort

    cheers will try that
  3. O

    numerical sort

    i tried including the origional date field but it screws up all the data
  4. O

    numerical sort

    i have a query that returns data per week number. To obtain the week number i used this : Format([Date],"ww"). This gives me the week numbers great but when the query is sorted the week numbers are not sorted numerically, ie i get this 1 10 11 12 2 3 4 5 6 7 8 9 is there a way to sort my data...
  5. O

    Dynamic data labels in for pivot charts

    i have a database that uses queries to create pivot charts to display the data. The query asks the user to first enter a month and a year as a filter and then displays the chart. My problem is that because it asks the user for the month and year it doesnt display the data labels on the chart...
  6. O

    locking a record

    Thanks very much Bob, your tip worked exactly as i needed it too :):)
  7. O

    locking a record

    cheers Bob that sounds just what i need, will let you know how i get on
  8. O

    locking a record

    can i set up a form to only be able to view the records and not be able to edit them, but if i click a form button i could then be allowed to edit. I want this to stop accidental editing of records.sorry for being a pain
  9. O

    how to automatically set a variable to the system date

    again thanks very much guys
  10. O

    can i turn off the toolbars?

    cheer guys
  11. O

    access data to excel

    I want the results of the query to be a bar chart or possible a pie chart The query returns this sort of results. Shift ID | Shift Type | Summary of Shift --------------------------------------- 1 Day Shift 32 2 Night Shift 62 3 Weekend...
  12. O

    Access and Dreamweaver???

    sorry forgot the link, its www.webthang.co.uk
  13. O

    Access and Dreamweaver???

    check out the tutorials on this website, they are pretty good and helped me get a better understanding of access with dreamweaver
  14. O

    access data to excel

    is it possible to send the results of a query in access 2002 to excel and for excel to create a chart from the data automatically instead of just creating a data table in excel and my having to manually create the chart
  15. O

    saving Query data into table

    Thanks for the reply. worked a treat
  16. O

    saving Query data into table

    Ive created a query that asks the user to enter data (month and year) before it can be processed. This is causing a problem for me as i need to produce a chart from this data and access isnt letting me (access doesnt like me asking the user to enter data). So i thought if the data could be...
  17. O

    are charts possible in access

    Im sorry to be a pain but ive just realised that it shows the chart when im in design view but not when im in form view? why not?
  18. O

    are charts possible in access

    doesnt seem to work with my query as i get the user to enter a date and the results are based on that date entered. here is the query SELECT Shift.Field1, Sum(Main.Shift) AS SumOfShift FROM Shift INNER JOIN Main ON Shift.ID = Main.Shift WHERE (((Month([main].[date]))=([ENTER MONTH]))) GROUP BY...
  19. O

    are charts possible in access

    id preferably like to do this without exporting to excel
  20. O

    are charts possible in access

    i need the results from a query to be displayed in graphical form ie bar chart or pie chart. is this possible in access and if so how?
Back
Top Bottom