Recent content by helpaccess

I have two table that contains data. need to find the ones that are missing using a unmatched query. It is using dates. so I would liket o find the ones that did not have the dates.

Access 07 I have the queries set up but I can nt select them only tables.:(

I would like to create a report using queries instead of tables. I go a blank design and all that comes up is the tables for me to use how do I get the queries instead.:(

Question, I am creating the new data base with the tables you suggested. I have some question. On the employee table. All the information is stored in a master table that is linked. Should I create my own? Also how do I create the foreign key and link it to the team data? Do I need to...

Will I have to start over? On some of my queries I have formulas. How do I get them too a table? Yes I am tracking expense by adjuster by travel team. They could have multipal teams per year. Here are the ones that are formulas in the two queries Expense: # days # weeks Meals/day...

query question. How do I take two queries (QRY_Incentive Bouns Pay) and (QRY_Expense tracking) combind into one query to show only the expense. will need to to see on line for each person per travel team.

Ok here is what I have for the row source: SELECT [TBL_Travel Team code].[Main Code], [TBL_Travel Team code].[TT Name (Location)] FROM [TBL_Travel Team code]; But when I go back to the form only the Main code is there. I change the code to main code. Here is what I have for the subcode...

When in the form I have the code box highlighted and then I cliked on change to and changed to a combo box. Now I cliked on the properites where do I go from here.

What table do I need to be in to change the code from a text box to a combo box and where is the column(x) property located?

ok I will try that and let you know. maybe you can help me with something else. I would like to have a lookup for the code subcode and only see them once also have the location be there to.

There you go. thanks for you help this far.

When I save it you only see the tables. how do I get the rest.

Here it is. The table and queries are (Table) traveling expense tracking (Query) detail expense tracking and form:expense tracking

This the date in the Query(sample not all) ID 799881 Name Year 2009 Code 019 subcode A When I pull up my form and look up the ID there is no data.

the data entry is no. All the rest are yes