Search results

Hey i have finally got around to create my actual db, putting into practice what i have learned in these forums over the last couple of weeks. This is a bit of background on why the db is needed... What im trying to do is convert our excel spreadsheets to a db. This has the benifits of giving...

Is it only possible to have one value "crosstab"? So the following crosstab query design is impossible? Field..........Field A..........Field B............Field C.............Field D........Field E Table all fro the same table Total.......Group By........Group By.........Group...

Hey guys This is the problem, I have 2 fields in a table. Cityand Country. City Country paris.......France madrid....Spain london....England milan.....Italy Rome.....Italy ETC Field "City" is connected to a combo box and field "country" to a textbox on the form. I would like the user to...

Hi, is there anyway to display the results horizontally? if these are the results of my query Results 2 2 3 4 6 8 Normally they would be diplayed just like that in the report. What I would like is to have them displayed like this: Results 2 2 3 4 6 8

I have a table with the following 4 fields (these are the ones i'm having the issue with but there are others). ID, Country, City, Date I enter data into this table via a form The ID is an auto number. The date is simply enetered. The Country Field is a lookup (in the table itself) with the...

Hi, I have a table with the following 3 fields (these are the ones i'm having the issue with but there are others). ID, Country, City The ID is an auto number. The Country Field is a lookup with the following lookup properties Display Control: Combo Box Row Source Type: Value List Row...

Cascading Combobox record source Hi, I need help on cascading combo boxes, in my form In my example DB i have 3 tables(when i find a soloution i will implement it on a larger scale database which will have around 15 tables). I need to create reports of these tables. The problem was that i...

Hi in the attached database there is a form called "with table select". I want to be able to select any one of the three tables i have in the top combo box. When this is done the bottom 2 combo boxes will display the relevant data if needed (look at the other form "myform" to see the fields...

Hi, I need to sum the sums of groups (stay with me!). This is the rough report layout: DETAIL SECTION in red GROUP FOOTER in blue Value 5 77 12 Sum (this sum works) 5 3 5 Sum (this sum works) Grand sum (Sum of the 2 sums in above example) Ive tried putting the grand sum in the page...

Hi first time here goes… I’m querying a table to filter by month using a parameter. For example when you run the query the parameter box pops up and you enter the month for which you want the data from eg month 11 for November’s records. However there are cases where I want all the records and...