Search results

A simple select query to place an auto number of 1 in a field. Hi guys, not sure what the code is but I just wish to create a simply select query that uses an auto number of 1 in a field. Basically we have orders being downloaded yet they have no quantity purchased, but each order is treated...

Worked like a charm, thanks!

Hi there, I have created a simple VAT query that calculates tax of 20%. However it displays more numbers than it should do, I wish to set a cut off limit for it. I have this so far VAT: Sum([invoice table]![Total Price]*17.5/100) which would display this: 49.392. I would like it to display...

Scratch that I've just figured it out duhhh. I didn't add the asterisk to Like "5055*" so now it becomes Like "*5055*" thanks anyway.

See I tried something similar however I can get it to place the asterisk after the barcode, but it will not return anything when I try and place it at the beginning. :confused:

Hi guys, I have created a simple select query that pulls barcode numbers from a table. I would like to include a Asterisk before and after the numbers, however I'm only pulling in certain barcodes :- Like "5055*" in the Criteria section.

Nevermind, I have found out how to do it.

Hi there, I created an invoice report notice with number of items, however I wish to include a text box or label to sum up the number of items at the end. For example a customer orders 2 x A and 3 x B and I would like the total number of items at the end which would be 5. My field is called Qty.

For example if we have a code of ZAALEX2234, if I typed in ZAALEX it would return all the ZAALEX codes starting with that. If I typed in 2234, it would return all the codes with that number in the field.

Hi guys, I have a 2 questions on a couple of queries I have built. The first is on total quantity on products. For example we send 2 products of X to a company and then send another 3 products of Y to the company which would be 5 in total. I wish to set up a quantity total to invoice them. My...

well I created a select query with the sum method subtracting quantity-order from qnty with returns what we have in stock. Now I have added a filtering of data that prompts the user to enter DD/MM/YY. When you enter that say I selected today's date, it returns all the orders that was placed on...

thanks! I basically did a create table query that is based on date. So when I enter today day it pulls up all orders of today, and what we have in stock and what has gone out.

Like I said mate, its basically the way he wants it! Until I have time after christmas to rewrite and create a brand new DB. :confused: The way it was explain that when we send reports to Amaazon and other companies they want it in a text file. Now if I create a select query just on calculated...

Hi guys, I wish to use a calculation to update my stock. Now I know you're not supposed to do this however I do not see any way around this to automatically update stock, as requested by my manager. I have created this function Left In Stock: [count]-Sum([quantity-purchased]) which returns my...

Hi, I didn't get any joy not sure if I entered it correctly though. Would it be Field - purchase-date Criteria - Like "*" & Format(DATE,"2012-11-21") & "*"

Okay I'm a still a bit stuck what do I need to post where? And no Jdraw the orders table is just linked to a delimited text file that is downloaded from Amazon.

Yes I do, its pretty much as you described it

Hi all, I have a question on how to run a select query based on date for purchases. Currently my date includes 2012-09-22T12:38:00+00:00, which when ran in query prompts the user for YY-MM-DD. I just want my user to be able to input the date as 2012-11-22, or 20121122, which will select orders...

Hi all. I could really do with some help on this. I'm trying to create an inventory Database, but don't really know where to begin. I have a stock table, a orders table linked to a text file. I have created a query using a sum method that takes into account the amount of stock we have left...