Search results

almost perfect Exactly what i wanted apart from the sum function doesnt work unless the dates are the same, is there away of making the hrs sum without the dates having to be the same? Thanks for all your help

can you have a look at this Hi Murli Thanks that works great, i was wondering if you could have a look at the sample attached and tell me why it isnt grouping on one i tried to recreate. Also you can see i have added a date function to it but i was wondering if i choose between 2 dates then a...

Wierd Error Thanks for your help Murli i have done what you said but when i open the form in form view the screen goes blank below is what i have in my query [Forms]![DateSelector]![hrslimit]

Sort of Yeah sort of Total the values for all the businesses then give the user the option to only print businesses off with a total say over 25hrs or 15hrs what ever they type in does that help?

Hi Right i have Consultancy Database, and im trying to get a report query together that will give me what my client wants: I gather the following information from my tables Business: cu_id cu_name Consultancy: cu_id co_id co_subject co_description co_hrs co_date These tables are linked via...

Cheers Thanks for your help I used GHudsons method works fine

Right ive searched the forum and people are just asking silly questions that can be answered with an input mask but. What im looking for is to be able to type a name for example in one textbox and the textbox will Capitalize the first Name and recognise the space key has been pressed and...

a Moonbase With

Hi, I have a date field in a query and was wondering if anyone knows how i can have a prompt to choose between two dates. Thanks Alex

Hi am am trying to construction a consultancy time query, what i need to do is to be able to selectr criteria for the following: Business Name - Drop down box that will report on a desired business Time Spent - Greater than a certain figure and less than a certain figure Date Between - Choose...

Figured it out Dosent matter i figured out myslef if anyone else comes across this problem use a different query to display a list of businesses and using your vbscript for opening a record open the form with your details in the name will still be displayed fine

Hi I have a list of company names in a form which gets its records from a query some of the companys have more than one entry, is there an way i can group the entrys so it only displays them once? (removing duplicates is not an option as the query is made up from 2 tables and it is needed to...

I figured it out but I manged to figure out what to do by using a query and subforms so it works now but it shows the same business everytime is has a vacancy on it so say a business had 3 vacancys the business would be shown 3 times in my listbox i tried grouping in the query but it doesnt...

Right I have a Table 'Businesses' which has about 600 comapines on it, i have another table 'vacancies' which has vacancies matched to a business. What I want to do is to be able to pick a company from a list (I can do that bit) then have a form displayed with that companys vacancies displayed...

Like this is, you know how? If you have a look at the attached picture that is a screenshot of what im after, you can see a list of vacancys with company names next to them and they where collected from 2 tables and when you press view it opens the vacancy details up. and id like the same for...

Hi dont know how im gonna explain this but here goes, I have a table of businesses and each business has vacancies and consultancy time under it through related tables, so i have Businesses | ------------------ |.......................| Vacancies........Consultancy I want to be able to...

What about if im not using querys? Im not using a query for the list what i have is a listbox with company names in that on double click open a form with that companys details on and i just wanted that list sorted alphabetically to make thm quicker to find cheers

Hi can anybody tell me how i can make a list box alphabetical and it updates as new records are added Thanks

Hi, I have a database with table 'Businesses' and 'Vacancies' what do i do to match a vacancy to a business, I have tried many ways and tried to understand it all. Im a bit of a noob at access and would really appreciate any help you can give me Thanks

Right I was wondering how i go about opening a form in a subform via click of a button e.g I click 'Bus Details' and it opens in the subform I Click 'Orders' and it opens up in the same subform. Thanks