Search results

i have a query based on 3 tables, 2 tables (table 1 & 2)contain 10k records each, the 3rd tables (added very recently) only contains 3k records. My problem is that when i run a query to show all relevant data from the 3 tables it only will show the most recent records (the 3k from the new...

please help me i have a date field called open & i need to generate a query to count all entries by month, so far i can get all cases each day, but i'm unable to get the query to count them just based on the month & year.. any ideas please

i know that data should not appear in 2 tables. but on this ocassion i really need this to work i have 2 tables table 1 & table 2, table 1 generates the ref code in the field "Ref" 40001 & so on (autonumber). i need the exact same number to be duplicated in field "accref" in table 2. this is...