Search results

Cheers thats done the trick!

I have created in a form a questionaire that goes onto 7 tabs, how do I automatically tab after the last record on tab 1, to take it straight to tab 2, without pysically clicking on tab 2.

whats the critera then??

DateAdd ( interval, number, date ) seems ok but specifically i need to show all dates 30 days from current date (todays date), so that when i run the report I get all records that are coming up!

How do I return data to show the next 30 days from todays date

Think this can be fixed in the relationships area might be wrong!

or dont get me on that took ages to get there, i needed from a badly organised database to calulate a field in a query based on the answer to 20+ questions, if one question returned No then the forumala I used all be it long winded was: Expr1: (([A1] & [A2] & [A3] & [A4] & [A5] & [B1] & [B2] &...

Hi all I have a field that returns either -1 or 0, -1 I need to convert to Fail and 0 I need to convert to pass in a separate field, any ideas!

Surely better exporting to Access matey, you will have more reporting capabilities!

Hi I have developed and designed literally 100's of Crystal Reports, some basic and straight forward, some very complex pulling in onformation from dozens of tables etc, I also always ensure they look professional, and I love designing and writing them, my only problem is I dont have any...

have you fiddled with the format of the formula feild, that may help, I dont have Crystal no more, so cant check it out for you sorry, failing that use a calculation that does return 15%, might mean dividing by 1000 or something, sorry im not much help!

Good morning, I am just starting out in VBA, having gone through Access 2000 manual, and now on VBA for dummies manual, and it seriously does take some getting used to, Im assuming this is a good site for any help, any other good manuals around to assist. Regards Simon

Mike if its worked your a star, all results that have failed, seemed to have returned -1, all results that have passed have seemed to have retunred 0, ill just check the data now.

I put that in the field and i cam up with Syntax error (comma) in query expression) 'Questions.[hasno([A1],[A2],[A3],[A4]....ETC, [D3],[D4])]'.

OK can I add a field the has a calculation along the lines of If Q1 = No then Fail or if Q2 = No then Fail or if Q3 = No then fail etc etc else pass. How would i get that forumla into a feild????

OK can I add a field the has a calculation along the lines of If Q1 = No then Fail or if Q2 = No then Fail or if Q3 = No then fail etc etc else pass. How would i get that forumla into a feild????

Where do i put the formula matey, is it a separate query or a field in a table, dont understand sorry!

I dont understand sorry bud, separate record??, for each person there is a subdatasheet, which has a separate feild for every question, they have a drop down option of Yes / No / N/A, like i mentioned the only difficulty is running a query on the entire database where a No is found in one of...

Sorry i have 20 fields for 20 questions each is yes or no, and i need to show the data if just 1 question turns up a NO, this applies to all 20 fields

Hi again I have a database that record answers from 20 questions (Yes, No, N/A), and I need to run a query to show me ALL records that return a NO answer, I tried putting "NO" in Q1 then going down a level to OR 'NO' in the Q2 and so on but i ran out of spaces, any ideas to make it simple!