Search results

Let me explain this a little better. I have 2 main tables. The first table is a running list of all orders that a rep has sold. We generate our payroll based on this table. We have a thing called reserve here and what we do is take 10% from everyone's pay and when they quit they receive a...

I am working on a payroll database. I have everything finished except I need to sum values from a query and place the total on a report. Everytime the payroll report is ran I take 10% of the final pay and append it to a reserve table. I want to be able to show the their total reserve on the...

Thank you that worked perfect.

I'm using the the findfirst method to bookmark a record. Can someone tell me the code to say if the record is not found? I know I've seen it some where on here before but I can't find it now. Thanks.

First let me ask you this... do you have a field in your table that is unique to each file that is imported? Like an Import Date field? If not you could create one at the end of the table and just set the default value to Date(). Once you have something like this you can create a log table...

Thanks that worked perfect

Nevermind I figured it out, I was using the transfertext when I should have been using the transferspreadsheet. But does anyone know how to specify a worksheet. I know you can specify a range but I want to import a specific worksheet without knowing the range.

I'm trying to import an excel file through code with the docmd.transfertext but it tells me that it can not run because the database or object is read only. Can anyone tell me how to fix this please.

I got it to work. I added an ID number to my queries and sorted by the ID number. Thanks anyway though.

Ok I got it to sort the way I wanted them in my union query but it's now sorting them in my crosstab query

Pat I'm a little confused by what you mean. I'm not very familiar with union queries. Could you explain a little more please? Thanks.

Thank you soooo much Pat, I just created a simple form with two text boxes for the criteria and a button to run the report there and it worked great. I've been pulling my hair out for two days now. Thanks again.

Pat can I do it with a report field or does it have to be a form field?

Someone please help.....I've tried moving the criteria to the the union query I have that the crosstab query is based on and the report still asks for the criteria twice.

was it a select query or a crosstab query. I tried doing what you said in my crosstab query and it still does it.

I have a report based on a crosstab query which has an input box for criteria. When I run the query it asks for the criteria once but when I run the report it asks for it twice. It even asks for the criteria when the report is closing. Does anyone know why it does this or how to stop it...

Actually it's sorting them in my union query first. So is there a way to specify the order in the union query? I'm combining 3 queries and I want the one query to display the records first then I want the next query to display and the third to display last but it's sorting them in acending order.

I have a crosstab query and I was wondering if there was a way to sort the row headers besides in acending or decending order. I tried not sorting at all but it's still sorting it in acending order. I know you can sort the colomn headers in any order you want but I can't figure out how to sort...

Ok scratch that last reply I figured out how to combine what I needed with a union query. Now can I create an append query or a crosstab query based on the union query. I'm not familiar with these types of queries.

Unfortunetly I must have different tables but we did just add a transaction table which shows what time something is changed with an order. It shows all of our entries for each client and what was done with the order. Whether it was received, exported, etc. So I am using that table. Now the...