Search results

Hi David, Thanks for your reply. I have to produce a database for a jewellery shop. Stock in, stock sold and stock carried forward on to the next month. The only thing I havent worked is how to carry the [stock remaining] figure forward into the [stock in] field of the next month. Do I use...

Ive been wasting so much time, now I only have the five different fields, and have created two one to many relationship to porduct id and order id. Thanks for your help. However Im still struggling to carry forward data. Is it a pain for the user to look at previous stock take and transfer...

Thanx very much, it helped a great deal

So do I need 25 tables, and create a relationship, from main to the other 25. I cant see this as being right. e.g main, stock id to table 1, stock id. I just keep having to copy and paste tables and queries all the time, and renaming them, differently.

Whenever I use access I always find myself, putting together hundreds of wueries or fields, does anyone know why this is. the latest a stock control database, where a shop has 25 different types of stock, means I have built a form to allow for the 200 fields to go in it. e.g stock in 1 stock...

Does anyone have a basic stock control database that I could purchase and change to suit my client. Stock in, sold and carried forward to next stock take. I would be very grateful

Is it possible to leave a field in a parametr form blank, and it will still run query. For example, if I have three fields on a parameter form, stock take nummber, shop area and stock takers surname. Supposing the user only wants to extract information on stock take number and area and is not...

Im only a novice, is there any way in which you, only see the result of the latest query instead of it giving you all the records, thanks for your help

SELECT [Table1 Query].[STOCK VALUE], Max([NUMBER]) AS MaxDate FROM [Table1 Query]; WHERE Group By [STOCK VALUE] What I want is the most recent STOCK VALUE, from the last record, to be showed. But this doesnt seem to have worked. Can anyone help me

I cant get it to work, each new record must look up the value in the last. so waht should the end strinc read

=DLookup("[StockPrice]","StockTable", "[StockID] This is what I have, I want it to look up the stock price from the previous record and place it in stock id in new record. Is this right.

Not tables, just records

Ive looked and cant find anything relevant. All I need is a dlook up function, that looks up the result of a calculation in the last record. Can this be done

Ive created a stock take database and want one field in a new record to be updated, when the previous one is filled in. For example, when the stock quantity is known, I want the amount in stock to be added to the next months stock form. Does anyone know how to do it.

How do you get calculations in reports to add up even if there isnt a value in the field.

thanks it worked well

The expression you entered has a function name that Microsoft Access cant find.

Is there anyway you can link parameter queries, so it doesnt ask for the same information twice SELECT Avg([F COST]) AS AvgOfCost FROM [T_IN SURVEY] WHERE ((([T_IN SURVEY].[F EST LIFE]) Between 0 And 6) And (([T_IN SURVEY].[PROPERTY GROUP])=[House])); next SELECT Avg([R COST]) AS AvgOfCost...

I have a report with many queries in. I want to set them to paremeters, so the user can simply specify what they want once. e.g show me all records of children over [how old] - say ten. However it asks me to specify the age for each one. Is there anyway to link parameter queries. Sorry if this...

If i set a paremeter query, how do I get the selected paremeter that the user has chosen to show in a report I know the sql for dates - beggining and end but not others