Search results

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...

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

=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.

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.

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

HOW DO I SEARCH ALL RECORDS, DEPENDING ON CERTAIN REQUIREMENTS E.G USING A MIXTURE OF COMBO BOX, CHECK BOX AND OPTION BUTTONS SELECT RECORDS THAT MEET ANY OF THE SELECTED ITEMS. E.G LOOKING FOR A HOUSE FOR EXAMPLE, THAT IS RED, IS BIG AND IS OLD, OR IS ANY OF THE ABOVE THE CHOICES WILL BE...

does anyone know how to use a combo box to then go to a form. eg. combo box list has three choices cost form wages form insurance form the operator chooses one which then brings up the form

Has anyone got a good stock control example database, or do microsoft have one that I coule look at.

If I put in a few subreports into a report, and they are queries. Can I add them all up in the final report.

WHY DOES IT SAY TOO MANY FIELDS DEFINED IN A TABLE WHEN I HAVENT REACHED THE MAX 225

chow can you put two queries into the same report, from the same table

Does anyone know if there is an average if function. i.e show me the average of this field if it is greater than 5 for example.The field is a in this case Ive tried this but it doesnt work =IIf([a]>5,Avg([a])) The field may have 20 records in it for example - life expectancy of roofs amd the...