Search results

I have this major head ache with this problem. What I am trying to do is make automatic invoices from a query. What I want to happen is when my stock gets below a level a invoice is created. So far I have got a query to get all the records that are under there stock level. (this is all working...

I cannot define the fields as they are coming from a query, this query creates the new table which gets its fields from two other tables, which both have autonumbers (ID's) which I want to put into the one table created by the make table query. Thanks Olie

How do I put multiple autonumbers (with a query) into a numerical field? Thanks

I also like you first suggestion, can you please explain how I put autonumbers into normal number fields in the table that is going to be created from the make table query. Thanks Olie

Thanks. I will now attempt to see if your second suggestion works. Thanks very much. Olie

I am trying to make a table using a make table query. The fields that are required in the the new table are from multiple tables, however because the other tables all have autonumbers I cannot have more than one autonumber. What can I do cause i need both ID numbers from the seperate tables...

I am a high school student who is creating a database for my final work and I am completly stuck. I cannot understand what to do now I have normalised a table. I need all the information to be displayed on a form, do i need to create seperate tables? Also i am trying to create a invoice (as a...