Search results

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

Yes, I even redid the subform. THe subform is where I am entering in the data for a person.

Yes, it is bound to the query. The date is all in the query. But when I open the subform and bring up a person the dat is not there.

created a new data base. Need to bring in data from old data base. not showing up in the form. All data is in the table and query and subform query. Not in the data form itself.

I have a blank table. I would like to take that Data and have some of the fields be hard coded. can any one help. Please :eek:

Yes, I have a table and there is information that I need but it does not have anything in it and there is no common factor. Example. I would like to have Meals @$30.00 per day fix and also $.55 for mileage. and hotel rate left blank for entry.