Search results

Thanks for all your help. Stevegr

Already tried that with no change to the output. I am still geting duplicate records with different net counts. I think it is based on a per shift basis but shifts are not a field in my query.

Calculating totals from expression Hi all, I have a query that calculates the total number of books run on a printing press from a table. I type in the job ID number and it calculates: NetCount: Sum([Gross]-[RunWasteImps]) This works fine but it gives me totals for different days that...

Works but not set Ascending: SELECT [QRY_COMBINE_TABLES Query].[JOB NUMBER], [QRY_COMBINE_TABLES Query].[JOB NAME], [QRY_COMBINE_TABLES Query].VERSION, [QRY_COMBINE_TABLES Query].[FORM ID], [QRY_COMBINE_TABLES Query].[NET GOOD PRESS COUNT] FROM [QRY_COMBINE_TABLES Query]; Does not work, set...

I tried that and it didn't work either

I run a sql query for my combo box. when I change to sort ascending on any field, it stops working. When I take the "sort by" out of the query, it's OK. I had this sorting before. . . any ideas anyone? Thanks, Stevegr

Hi all, I have a form that has a text box for me to enter a number. After entering the number I hit a button to run a query to append a table. I usually enter around 5 to 12 numbers and continue adding to the table. The number is set as qriteria in a query. I would like to view the numbers...

Hi all, I have two linked spreadsheets from Excel. I have a Union Query that combines the two. Is there any way to have an Autonumber column to create a unique field? The unique field I need is required to get records from a multicolumn combo box. Thanks, Steve

Hi all, I have a linked table to an excel spreadsheet. Everything was fine until some of the data stopped linking. I have several columns and some of the data shows up in access and some of it doesn't. The columns are formatted as "text" in excel. Thanks, Stevegr

there are 4 column showing in my combo box. How do I set the bound column?

Hi all, Why is it that when I select a record from my combo box, that a different record shows up? Sometimes the correct record shows, sometimes something else from the list shows up in my combo box. Thanks, Stevegr

At first I had only Form 1 but split it into 2 forms because I thought that was my problem. I am trying to query info from the "qryKBAPressData" and have it displayed on a form once I select criteria from the combo boxes.

SKWilliams, I thought I had it but I guess I didn't I emailed you the database.

Never mind, I think I got it. I had to use a blank form without the combo boxes that I was using for setting the query criterea. Thanks for you help! Stevegr

Will your email handle that size?

The database is too big for this Forum. It's around 8 meg

I understand what you mean. But when I change the record source on the form to my query, a blank form shows up when I switch to Form view for some reason. when I remove the record source, all my controls are viewable again on my Form. Any ideas Thanks, Steve

If I understand the question. . . No the records are already in a table that I am querying.

Hi all, How do I get the query results to show on my form. I tried using a subform but the layout wasn't what I wanted so I thought to use individual text boxes to rearrange them to suit me. But not sure how to send the query info to the text boxes on my form. Thanks, Steve

it worked, thanks for your help