Search results

Hi, I am setting up a subform that will update 2 tables: products in stock and products on order. the main form is for stocktaking purposes. What i want to do is have an unbound combo that lists all products, a field for products in stock and a field for products on order. I want to display...

It would look like a really ugly spreadsheet, which is what it is being modelled off. I have already a report that shows what products were in use on a date or through a series of dates, along with several filtering options. This is just another view of the same information that i have been...

My goals are to view the information exactly as outlined in the last part of my post above. I'll probably put it onto a form in a locked datasheet or something. My database stores the start dates that lot numbers of products are put into use. I want to view date by date through a range which...

Thanks Galaxiom, that put me on the right track and now i have a query that shows all the gaps in my data based on sequential dates. Which brings me to my next problem: So the data that i have filtered shows lot numbers (lot) of products (product) listed on the date that each was put into use...

Hey, I have a query that pulls data out between 2 dates which works as it should (showing entries and their corresponding dates), but is there a way to show every date in that range, sequentially, even if there is no change on those dates? Thanks for looking.

Thanks pbaldy, i looked but i couldn't find any good sql examples, but you got me thinking on the right path and i solved the problem. This is what worked: SELECT prodname, lotno, in_use, out_use FROM tblmedia WHERE (((out_use)>=[Enter Start Date] And (out_use) Is Not Null) AND...

Hi, I have been looking everywhere, and i can't find a solution to my problem, so i'm hoping some one here might be able to help. I have a table, tblmedia which has several fields, but for this i am only interested in: prodname (text field) relates to a product name. lotno (text field)...