Search results

backgound:- I have a report that lists people from different areas i.e (field called : district) Newcastle Sunderland In each line of data it will show if that person has for example been to event A,B or C (yes/No) Fields called (A,B,C) Is it possible to include a formula at the end of this...

Ok let me explain I have a list of 50 people who may have accessed events A,B,C at different times but what I want to do is to put a date in my form, run the quaery which will list all people who have Attended A,B or C When I do my normal query, I put the fields in, but if I put a date filter...

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...

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...

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...

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 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...