Search results

Ok, I have been bashing my head agianst my keys for a while trying to work this out. i have the following queries that ware working as intended: JNCOfinder (queries TblPersonalinfo for people who meet the critera for the JNCO course) SNCOFinder (same as above but for a different course)...

had a look at that, it seemed to display a formoo with info from the previous form, not exactly what i was after.

i need a button to go on my form that displays results of a query. i need to open a different form depending on the value of one of the fields Ie. crstit = JNCO run JNCOfinder, crstit = SNCO run Sncofinder there are about 5 possible results for crstit (at this stage, will be adding more...

Worked a treat thanks heaps

I have a query that takes data from 2 tables. one of the results from the query is: Paradecount: Sum(IIf([Onparade]=True,1,0)) i then want to put the result onto a form using: =[AttandacetrackerQuery]![Paradecount] have also tried Dlookup. i keep getting #Name? access 2007

Present:IIF([Onparade]=True,1,0) gives me the same data as the one i used. now i have thois data on the query i still can't get it on the form. i need it to display on the form [Personal Info]. the query is [Attendancetracker Query] current Control Source: =[Attandacetracker...

i finally got the query to give me the data i wanted. i used Sum([Onparade]*-1) and got it to spit out as an expression. now when i try to link that to my form i get #Name? even using the expression builder i can't shake this error

no where near letting this go live yet. so there is only sample data at the moment. it's there. have been playing with it today, cadetcourses table is my "inbetween" table i don't need to concern myslef with lecturers as thats handled at the national level.

I have a table made up that contains the fields. [CDTID](number) [ParadeDate](Date/Time) and [OnParade](Yes/No) i need to make a query that will find the CDTID and how many OnParade records return yes would also like one to total all the OnParade results unconditionally so i can work out the...

had an idea last night that might fix my issue. if i create a new table to store historical information on who i have sent on courses and use an append macor to recover personal infor and couse info to that table before taking it to the form. does that sound as if it should work?

the data that i want to put on the replicated paper form is sotred in 2 seperate tables. 1 form contains all the personal info (name age, next of kin, medical info ect), the other form contains the course information, (name of course, dates and location) w ant to have it set up at the end of...

My Database is coming along well, but coming into a bit of a pickle trying to make it do one of the sole functions i made it for. we are required to fill out standized forms (on paper) for any course we want to attend. i thought it would be simple enough to do since it's a word doc. i...

the one still had be lost. but it did link me to one that did help, thanks

Absolute Newbie here. help with Datediff. (SOLVED) I am writing a database for a youth organiseation i am involved with. i need a fields for: age (years and months from [DateOfBirth] to today) ageforcourse (years and months from [DateOfBirth] a specified date , possibly [coursedate] if i do...