Search results

sorry, ideally i would like to data to show as 12/01/09,13/01/09,14/01/09 or 12/01/09 to 14/01/09 and i did this,i did that,i did some more thanks

hi, is it possible to combine dates and text fields into one field, lets say i work on 12/01/09 13/01/09 and 14/01/09 and want to show those dates in one field as dates worked, and while i was there i worked: i did this, i did that, and i did some more, i have set my queries up to...

so its more of a relationship issue than a query issue?

thats what i thought but i seem to be getting problems when i create to many queries which brings me back to an earlier post http://www.access-programmers.co.uk/forums/showthread.php?t=164467 ive learnt loads today and now come to a grinding halt :(

i have started my db again and changed quite a few things (for the better i hope :) ) but i was kinda hoping my problem with the duplicate data would have been an isolated issue but it appears i must be making the same mistakes as before, i would be very grateful if someone could take a look...

when creating forms should i create them from my table or create a query first from my table then a form from my query, thanks w0od0o

thank you both, got it working now :)

i have created a query and formated the data to the first 3 letters of the month but they display in random order apr jan feb ect... is there anyway of getting them to run in month order jan feb mar ect... thanks w0od0o

here is a copy of my db, hope this helps

hi, i have created 3 queries and now i want to create a 4th to filter all the data to certain dates ect.. but when i add all 3 queries into 1 using all fields in the queries i get duplicate data, i think it has something to do with the foreign keys but unsure on how to remove the problem...

you great thank you

thanks again, last but not least how do i get the values to display as currency? if i have.... total: [cost]+[vat] would there be some way of tell it to display as currency?

another quick question i hope, ive decide to use a query to do my calcs but should i use the data from the table, query or form to work out the calcs? thanks w0od0o

thanks both, so the total field in my table is redundant and should be removed?

hi, i am looking to try and get 2 fields in a table to add together and then show data in another field for examaple: cost + VAT = Total which would be the best way to do this, in a table, query or form? thanks w0od0o

yes it is set to data entry, i wanted to have it so as the user can input new clients but would have access to the other clients unless they wanted to edit the client,

hi, im trying to filter data from my table so i can edit the data in a client table, i have created a form to open and add a new client and all works fine, but i can not get it to to open the same form but containing certain client data to edit after its been added. thanks w0od0o

got it thanks :)

just a quick one i hope, whats the best way to het the data from a AutoKey to ForeignKey without having to type it? i have them in a relationship but cant get them to pass the data down thanks w0od0o

have tried to add all my fields from my tables to a query but i just cant get it to look up the data to add to the invoice table have uploaded it, if someone could help thanks w0od0o