Search results

....thanks. Any idea how it may finish as well!??

I am hoping someone can help me here. I have peoples surnames that I need to be in all uppercase but for Surnames beginning with MC (i.e. McDonald, McKay etc) I need the 'c' to be lower case so that names display as McDONALD and McKAY. The same foe a few that begin with Le (i.e LeCRAS). Is...

Hi, Im thinking this may be pretty easy but I dont know how to do it! As attached, I have data in a field and I want to write a query to return all the values except the ones that have 2014/* in them. So I want to see the blank ones as well as the one with 2013. So I basically want to return B...

Hi, Im a bit of a hack when it comes to queries but I have two tables, one with a heap of data in it and another table with some of the data from the first table in it. Can I create a query that will tell me the data that is in the first table but not the second table? Both tables have a common...

This is more than likely a basic one but just one of the many things I am trying to get my head around since upgrading from 2003. I have an existing report and I want to change the source of some of the fields. Stupid question, but how do I display the existing data source (table / query) for...

Thanks. Im not up to speed with forms etc so just wanted a query based on a table that contained all the data. Ive attached an XLS. The yellow column is what I am hoping to see in the query next to the name and data.

I am hoping someone may be able to point me in the right direction here. I have a table with peoples names in the first column. In the 2nd, 3rd, 4th etc columns I have data on them. I would like to have a query that, when I run it, displays the names and then after the 1st column of data, has...

Hi, I can calculate the age now worries. I just want to flag if a person has an age between 18 and 23.

Hi, I am battling with this one and Im sure it will only take someone 30 seconds or so! I have a query that returns people's ages. I want to write a query / formula to return a 1 against the ages that are between 18 and 23, and a 0 for the ages outside that range. Can anyone help me...

Hi, Thanks for that. Is it possible to generate the autonumber in the query that I base the report on, as opposed to the table?

Hi, I'm not sure if I'm posting this in the correct location or not. I have a database that connects to the Internet and updates tables. I am hoping to extract data out of some tables into Excel and then manipulate the data. Is anyone able to assist me in doing this, or point me in the right...

Hi, I know I can create a report whereby I produce a line under each row of data however is it easy to create a report that displays the line after every 5th or so row? Thanks.

khawar That worked beautifully. Thanks for your assistance.

Hi, I have a table with a sporting matchID, stat transaction number, and a stat code linked to the transaction number. I would like to create a query that returns the minimum transaction number of a particular stat code for each matchID. Is there an easy way to do this? Each matchID has 1000...

I have the club name (which is what I want to group the pages by) in the Page Header of the layout and in the grouping settings box, have it set to: Group on each value Group Interval - 1 Keep Together - whole group Some of the club lists spill over to 2 pages so I want to still displa the...

Hi, I have made a report based on a table. In the first column of the table is a ClubName. There are 12 Clubs with about 30 or so rowws in them (i.e. 30 of Club named 'North', 30 of Club named 'South' etc). I have created a report based on this table and am grouping the pages by Club (or...

Hi, I am trying to design a report and want to line up the vertical borders in the detail with those of the header. Is there any way you can zoom in so you can get them precisely in line? The column widths across the report are different. I know I can snap to grid but some of my borders arent...

rak, thanks for that however I was hoping it would return 4Y 0m 3d. Is that possible?

Hello, I have two fields in a table, both containing dates. I would like to write a query that returns the difference between the dates in an year, month, day format (i.e. 26y 2m 3d). If that isnt possible, can the difference be returned as years,days (i.e. 26y 63d). Thankyou.

Hello, I am trying to work out how to find the difference between two dates, in years and days. I have a [date_of_birth] field and another field [date] and wish to work out the difference in years and days as opposed to decimal years. Is it possible to do it? Thanks.