Recent content by Tansar

Hi, Each time I add an a link / tag; all my links show the # sign. Eg: <li><a href="#">Link 1</a></li> Will render: Link 1(#) Is there any way of gettting rid or not displaying the (#) ? TIA :) Dreamweaver CS5

Thanks for the reply. Ward is already in...:) Here's the SQL view of the query: SELECT tblRequests.Streets, tblStreets.Ward FROM tblStreets INNER JOIN tblRequests ON tblStreets.Street = tblRequests.Streets; :confused: Why are the other same named streets in other wards showing? I have 11...

Hi for some reason I am getting duplicates in my query :confused: What I have is Park Road. There are 3 Park Road' but in different Wards. The table has only 1 input of the word Park Road for ONE of the areas, yet all 3 areas show, like: STREET WARD Park Road DRO Park Road STA Park Road...

Hi, I am trying to calculate a total of a column based on a criteria. I have in column B either "Y" or "No". I have in Column C a figure Column D (at the bottom) I have the total for Y AND the next row of totals for N. I'm kinda stuck. Do I use the If formula or the Vlookup or even combined...

Ok, ok...get the hint :D (sorry). Just asking a question on behalf of someone. There is a start date to some road works and an expiry date. If the expiry date is passed then we'd like Access to remind us (ie project 123 has expired, etc), rather than running a query (of some kind) everyday we...

Hi, I would like to know if I can have some sort of pop up that shows dates which have expired. Basically I want access to automatically tell me (upon opening which items/products have expired). Is it poss? Hope to hear. Thanks :)

Use the > in the formatting area (Design mode). :)

Thank you for your reply. :) What about the ORDERS table and where should I be linking this to? :o I've had a play with ith earlier, see attachment. Thanks.

Hi, I am trying to set up some tables for my DB. I have a list of Schools, Streets, (Council) Wards and ORDERS. What I'm trying to achieve, is to see which SCHOOL has an ORDER which STREET has no ORDER which WARD has what ORDER The street table has some streets more than once, as there may be...

Thanks guys!! :)

Hmm...ok. i have this: EXPR1: [TM] & " " & [TRO_ID] & " " & [TRO_Year] & "/" & [TRO_Engineer] Where would I add format to this?:(

Erm...:confused: My data type in my table is set as: Date/time. The format is set to yyyy. Yet I get a full date like 02/07/2008. I only need 2008 :o

Hi, i have got my year format set as yyyy, which displays the year only. But when I click on the field it shows the full date.:confused: This causes me a problem when concatenating two fields together, as I get the full date also. How do I solve this? I only need the year to show. Thank you :)

Nice ;) Thank you.

Thanks for that...:) I need to add more options to the group, and I'm kinda blank how to get the dialogue box to enter further options. :o TIA