Search results

i havn't gotten too far into this project so any suggestions are possible. I am writing a database to track our (and others) wine collections. i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right? just to...

Once more i am having trouble wrapping my head around Dcount. I have a survey, the results are stored in TblSurveyClients. i have a field in there called location, one result is Tokoroa I am trying to make a form to track how many people have responded from each town. i have an unbound box i am...

I need a way to get a count of records matching multiple criteria. Table: TblCadets Criteria: [Rank] = U/O, [Gender] = Female, [Active] = yes the table at the moment has 1 matching record. this my be the sticking point. the number then needs to be able to be exported into an existing excel...

Hey all. I am building a database for a small training organisation. the database takes attendance at the moment, but i would like to migrate this to an android tablet. at the moment the roll is taken on paper, then given to someone to put it in the database. would like to skip that step so...

SOLVED: Append Query: Making too many records. I have 2 append queries behaving in a similar manner. one of the values i need to append is from a combo box on the form. it appends the correct values to the table but the number it appends in equal to the number of values in the combo box...

i have an issue with a query i am running. the idea is "this list of people can do this course" you click on who you want to do the course and i will work out the rest of the problems from there. but everytime i check "tempattend" i get this recordset is not updateable. could it be because the...

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

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

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

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

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

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