I've got two tables of various information about members of a club I'm helping run and I'm now trying to create queries I can use so I won't have to redo filters constantly to extract various information I need.
Where I have issue is that I create a query that pulls table fields from the two tables (linked via one-to-one relationship), and I need to only see members that are under 18 years old on the date I run the query (due to rules...
Daedalus
Last Activity: Feb 8 '16, 02:27 AM
Joined: Nov 26 '06
Location: Denmark
-
criteria for cross table query syntax
-
yeah thats close- I'll try that out see how it goes.
Thanks all for helps, links and suggestions...l ots of ideas to test. -
Yeah Guess I didn't explan properly - my bad.
Using Access 2007
The DB is for me to help me manage membership listings and such for a social club I'm the treasurer of.
Tables Members. Has values #, name (Primary Key), and various contact info details like mail, adress, phone, birthday, join date, leave date, status, type of membership, payment method etc.
Table Payment. Has values #, Name(Primary...Leave a comment:
-
Linking more than two tables
I'm trying to use relationships to link more than two tables.
Using referencial intrgerity I can connect two tables so that by clicking a small + I can open one inside the other for the various entries.
But I would like to add more so that when I click the + it opens tow or more lines below with the corrosping values entries in the other tables.
All tables have a unique number and Name field as options for Primary... -
That worked beautifully - thanks a lot for fast, easy to understand answer that works :)
Woooot!Leave a comment:
-
How to get Query to Filter/Count in Table
First, Greetings again all you great code helpers :)
In Access 2007 I need to get a query to basically do the following:
I have a table, (TableA) that has a column called Type. Type is a lookup and can have four values(Value1, Value2, Value3, Value4) which are determined when entering the entry in a Form.
I hope to be able to run the query and get the result displayed (eventually in pie chart format) where... -
Ok I've been over the tutorial a few times, I think that I'll have to do it again and again cause that was hard reading for me right now.
But I figure that the structure of the code should be along these lines:
IF [Checkbox:Januar y] Then print Table[Dues/Column January] to Report[Dues_Overview]
(obviously not correct formatted code, have no clue yet as to what that should be)
Repeated for...Leave a comment:
-
No problem with that, just wanted to stress the point that I am much more familair with Access thatn I am with writing anyything in code.
And that tutorial will be getting some me-time with me shortly.
Nice to know I only need the one button to operate the whole thing.
BUT since the form is set up so that all the code is in one command button, will there be diffucties in tying in the checkboxes to the...Leave a comment:
-
I haven't worked with VB code in over 10 years and that was an amateur effort. So help will definently be needed on that.
The checkboxes are all labeled "January, Febuary..." and so forth - one for each month
I also have one command button labeled "Show_Dues_Repor t" to open the report (Called "Dues_Report") showing the whole year.
Lastly I have one more command button labelled...Leave a comment:
-
Damn I was hoping to avoid using codes and I can't write that stuff.
Ok I now have a form that contains twelve check boxes and two command buttons. One button to open the report for the whole year and one that will operate the filter command.
I also have the report created to show the whole year.Leave a comment:
-
Need to create a selective(filtered) lookup report (thingy?)
Ok I'm once again showing my complete (or almost) ineptitude with all things Access.
I'm using Access 2007 and need to do the following:
SETUP:
I have a table of membership information, and a table of dues information. They are linked via a unique ID number so that I can see the data for each entry without opening the corresponding table.
PROBLEM:
I need to create a form (or... -
Getting rid of Ultimate Defender/Fixer/Cleaner
Can anyone help me get rid of this awful piece of (insert VERY explicit tirade here)
I found some guides on how to manually remove the Ultimate Defender stuff but:
The files does not exist.
The Proccesses does not exist.
The Registry Keys does not exist.
The only thing I have found is a piece of software called Spysweeper but that only scans in the free edition. I have to purchase it to get... -
Upgraded from 2000 to 2007 Version - can't recreate links to DB
I have recently upgraded from ACCESS 2000 to ACCESS 2007 (about time some might say)
I have several DB's that I use for storing various information, including accounting info for a club I help run.
Now that I've upgraded my entire system and OFFICE I went in to re-create the hyperlinks I used to have on my desktop. But I seeem unable to do so in this version.
I had made hyperlinks to a specifik form that... -
ok - well - dang - color me slighly more that usually embarrassed. that simple huh?
Oh well - many a thanks for the help.Leave a comment:
-
wow - that actually works well enough for me.
Just one question - sometimes after i hit the refresh data option in the query field I've created (just created one query with all columns and then used SUM to create a value field) the values get replaced by ### - but the actual values are correct in the field in the actual statement that uses the value field.
Should I worry about this or jsut carry on with it this way....Leave a comment:
-
Daedalus started a topic How to get the total sum of a table column in an Acces DB into and excel sheet?in AccessHow to get the total sum of a table column in an Acces DB into and excel sheet?
I need to make it so that a DB of a membership list I have can send the sum value of a column to a cell in a Excel spreadsheet.
Basically:
I have in Access a membership database which, among other things, includes a list of dues paid per month by each member.
In Excel I have the financial statements for said group. And it would really be fantastically helpful if I can make it so that the cell in excel... -
Well, sofar I get the query granting me the name and number for the printable dues page I ned to generate - but all the columns for the 12 months are missing.
The page I need to generate should look something like this:
Number, Name, Jan, feb, Mar, Apr, May, June, July, Aug, Sept, Oct, Nov, Dec
In the field names across - and each members data listed below.
the name field needs to be taken...Leave a comment:
-
Ok - here's a breakdown of what I'm trying to accomplish:
One table is to include Number, Name, Adress, Telephone number, E-Mail, Type of Membership and Method of payment.
This is the membership list.
One other table is to include Number, Name and a column for each month.
This is the Membership Dues list.
They have the name and number column in common now because the dues...Leave a comment:
-
Daedalus started a topic How can I update identical fields in several tables by only entering in one?in AccessHow can I update identical fields in several tables by only entering in one?
Hello all you brillaint people who might be able to help me.
I've recently become treasurer for a small club and need to create a membership database.
Now I'm almost a complete newbie at Databases - but i have managed to make small inroads.
What I need it some way to make it so that when I enter a new record in the Membership Table, it is also created and filled out in the common fields in the membership...
No activity results to display
Leave a comment: