Search results

do you have Teamviewer so you can access my desktop and help me? http://www.access-programmers.co.uk/forums/showthread.php?p=997087#post997087

Is there another method? because im not sure if im doing it right. I made another table by copying the amended data which shows 15 days or more from Length of Stay query and made a new Priority field with checkbox. Next i made a update query and everything in my new table gets ticked. But how...

Access 2007 I need help creating a query to update the Priority field in the Transaction table such that those visitors whose length of stay is 15 days or more will have the priority check box ticked. And i need to run this query to update the data in the Transaction table...

Solved, thanks guys.

ill update again whether i got it right! thanks for the help. namiliam just to clarify. In query design, i add IIF(YourField='MALE',1,0) to one of the field and IIF(YourField='FEMALE',1,0) to another field, Group by the first column and Count the 2nd column. am i right?

I'm sorry but im a beginner i don't really understand what you mean, do you have a step-by-step guide?

and how do i do that? How can i use IIF to split the Gender into Male and Female?

X is an example FOr example i want it to appear like Country Number of Visitors F M Singapore 7 5 2

do you have MSN i can contact you w ith?

What do you mean? i'm quite new to this

Access 2007 I need help with creating a query to show the number of visitors by countries, further breaking it down to gender distribution (i.e. by number of male and number of female visitors for a particular country). An example showing sample data: ---------------------------------------...