PHV
That is exactly what I have asked for! You are a star. I will now edit the SQL to reflect the actual table contents
Very much obliged.
thanks
Cliff
Hi Tek Tips members,
I have a temporary bill of materials table where several Product types are entered, the table is as below.
I have inserted the blank row for clarity.
Product, component, qty
A C1 2
A C2 1
A C3 2
B C1 1
B C2...
Thanks,
I tried the qty column and that didn't work as well!
But...
I have found the problem. The make table query that I used to initially create the temporary table from the existing data had put the qty column data type to Binary?
Everything worked ok except the summing. I just changed...
1. I am creating a stores picking list this requires the following user input
1a. Product Code (selected on a form via a combobox)
1b. Assembler Name (selected on a form via a combobox)
1c. Quantity (entered manually)
2. This fills a (temporary) table (contents deleted prior to each new picking...
PHV,
Of course they are strings! Duh what a prat! Thanks, that has sorted it fine.
Golom,
Thanks for your help I'll go with PHV for this one, it works fine so far.
Cliff
I have a query which retrieves 5 fields called attendance
each field may or may not have a name in it
I need to calculate total attendance, up to 5 people obviously!
if there is a null entry the query returns a zero if there is an entry the field displays a 1.
example of function below (this...
John, thanks for your help, will follow your suggestions, and using you keywords I will dig a bit deeper, again thanks!
ssatech, error handling? i suppose it crashes if this is not sorted? thanks for the advise will do some trials.
Cliff
I have an existing company database. It is split to allow different users to have job specific interfaces. As expected more users than MSAccess packages would like to use the core data. Rather than paying for full packages for these individuals who do not need to create there own database...
mp9
I returned to the office to find file access restored, My IT man has not changed anything he assures me. The first hint I had was seeing data.ldb file in the directory??? Anyway users with appropriate permissions are now able to open there queries.
AFAIK none has been given exlusive rights...
We have been using a Front end/back end database for 3 years now. Recently I have developed a front end with read-only queries to be used on the shop floor. Our IT manager has changed permissions to further protect the data. Initially a few read write users were locked out but after a few...
GingerR
I am looking at your first message, what does the text box do. Does the Form "Move" to the product searched in the combo box by virtue of the fact that the source of the subform is somehow linked to the combo box selection? I Can point the sub form to display the location table but can't...
GingerR,
I have created a form by adding a combo box and then dragging in a form that creates a subform, which according to help files (and if i understand your message correctly) should create the master child link providing such a relationship exists in the relationship section - which it...
I have a form that allows users to display/filter a 3 field table (Product, Part No, Qty) the default form allows users to inadvertently change the Product field and allocate the Part No to another Product, I need to make the first field filterable to allow the user to only see the cutting list...
I have a form that allows users to display/filter a 3 field table (Product, Part No, Qty) The problem is the default form allows users to inadvertently change the Product field and inadvertantly allocate the Part No to another Product, I need to make the first field filterable to allow the user...
traingamer
Thanks,
All of the parts that appear in ONE or the OTHER of these products but not in both?
Yes that is it exactly,
is this I suspect from your question - different to Unique?
Cliff
PHV,
Thanks, No dice I'm afraid
SELECT DISTINCT [Product Number], [Part Number], .Qty
FROM [Location Table]
WHERE [Product Number]=[Forms]![CSSimultaneousPanels]![combo1] OR [Product Number]=[Forms]![CSSimultaneousPanels]![combo2]
ORDER BY [Part Number];
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.