Search results

I have an excel file with a Vlookup, and it basically looks at 3 lists of post codes and reports if the post code entered is equal to one on the list. I am now creating a client database and would like it to do the following when I put the clients post code in - it will automatically check to...

can you not do an IF command that looks at the field for the tick box, and if it is ticked then the value is 1.5. not too sure of the exact command but =IIf(tickbox]="1","1.5","") This is in theory what needs to be done - It should work. - Probably If tickbox was labled tick then...

Not too sure which section this belongs in, and I know that you can help me with this little problem. I am creating a database and there are two main things I am trying to resolve. Can you please help. The database is going to hold peoples names, and these names will be allocated to a specific...

Surveys - I am having a few problems with mine. I`ll try and explain my layout and what I am trying to achive. I haev read numerious posts :( and am still having probs. Layout:- tblclient:- (holds all the clients details) name postcode etc.. tblprojects:- (list of all the projects - whcih...

I am trying to do somthing very similar, I haev 4 projects, each project has up to 10 differnt outputs. I am trying to create a similar database. I would like to have a tab section where tab1 would be Project No 11, tab2 Project No 32 etc. So each tab is a specific project, then in that tab...

Great.. I have done it. I have created two queries one that shows the totals count for those udner 300 and anther that shows those over 300... Just a little thought, is it possible to show these on the same querie? so I`d have the periods i.e April-June and then the next colum would have the...

Almost.. Thanks for the Moduel, I must get a decent book to read up on for access,.. Any recomendations.? I have got my list, BUT.. If I have data in 2002,2003,2004 when it groups the dates it also groups the data, so in my query it lists them like so:- Quarter CountOfCompany Name Apr-04 to...

thanks, I can work with that, now my question is: how does it define the dates? I am not ofay with the date command, so can you tell me how it defines the period i,e April-June 04 etc.., IF I wanted to make the period March-May (whcih I don`t do I just add-1)?> Thanks for this.

I have created a sample database, its got a few items in it, and 1 querie, The Query shows you that I am trying to cound the number of items that appear in a speciic date period, i.e. I haev 400 items over 2 years, so I create a Querie that picks out specific dates and counts how many items...

April 05 onward is open..so far, but I could just continue adding the dates..

I have a querie that has a list of items sold over 2 years, the fields in the querie are: Item Date (date sold) Cost I am trying to create a filter that shows the data in set time periods, so in my querie, I have 5 expressions that will be marked Apr-Jun04 Jul-Sep04 Oct-Dec04 Jan-Mar05 what I...

Bump.. anyone>

Hi, I have a group of figures that I only want to show the values for the last quater part of the year, the period would be Q1=April/May/June Q2=July/Aug/Sept Q3=oCT/nOV/DEC Q4=Jan/Feb/Mar What I want is for a filter to check todays date and use the data that falls in whatever period we are in...

I have attached my DB, its very very rough, but the main areas are:- project details and newoutput the two queires are:- _with_gs and expeced outputs :) thanks

thanks. I have nearly managed to do what I haev said above, the prob I have now is that I have two querys, and I wanted to deduct one value from the other, but its not doing it correctly, Query no1, has 3 headings in it whcih are the totals of a group of items that relate to each heading Query...

can you not create a text box with Forms![frmCardiology_MAIN]!['cboMonthOf'] in the subform

I have a query that has the following data. Project,Title,Value. I have used the crosstable function to layout the info, but what I want it to do is add up all the values that have the same titles (i.e. hg, nonhg) so my crosstable looks like this Project hg non hg other 10...

Hi, Firstly, Big Hi, just found this site and its great...and now I need some help. I am creating a purchase order system and I am haveing major probs. the layout is as follows:- I have about 9 projects, and each project mayhave up to 10 differnt sub sections i.e. Project 3, with heading like...