Recent content by emamekyd

Hello, Im still a beginner at these types of things but i'm wondering if I have a table of stickers that have been used/tracked that goes something like this : sticksused(stick_id, stick_begin, stick_end, stick_qty, date_used, company) with an entry looking like : (1, 100, 199, 100...

Okay that logic makes sense, thank you so much for your help! Sorry I am totally new on this kind of stuff and I'm a little confused on where I input that SQL statement . Should I make a new query that joins the current query I use as the record source that joins tCompany for the report to...

Yes this concept would work great! Sorry, i'm not a big coder but what would be the code to loop through a table like that? That would be the only information changing is the company name and the filepath - exactly the table you have there. I would just like to be able to export as a PDF to each...

Hi there, I have a report created that displays data based on which company name I enter into the parameter. I have to enter in each company individually and print each report to PDF to a separate location. Is there a way of creating a macro that can edit the query and then print out that...

Okay so it turns out its my data that's giving me issues. Something i've run across is this: BCLog BarcodeStart, BarcodeFinish, product 100, 400, Bananas 401, 500, Bananas BCUsed BarcodeStart, BarcodeFinish, product, ID 380, 450 , Bananas, 1 So its pulling it out as an error but technically...

For some reason this is returning all the records. I have thought through the logic and it all makes sense to me. Hmmm. :banghead:

Yes both can have multiples (Sorry for not clarifying that further) Almost all of the barcodes should be used up so the table would look like BCUsed 100, 104, Bananas, Monday 105, 200, Bananas, Tuesday 201, 400, Bananas, Friday And yes there is a key and also a date.

So using that formula you gave me, using the following data (im adding a 'key' at the end - just as a point of reference) : BCLog 100, 400, Bananas, 1 401, 500, Apples, 2 501, 700, Bananas, 3 BCUsed 105, 200, Bananas, 1 It is pointing that BCUsed entry out because it is less than entry '3' on...

Hmm, I tried it and I like that logic! But I have multiples of the entries in the BCLog that are showing up, for instance 100, 400, Bananas 401, 500, Apples 501, 700, Bananas So I need to figure out a way I can talk to only that range hmm. BTW I can use excel as well to help me with this

Hello, I need a sort of auditing query that checks to see if numbers are within a range. Here is an example of the data. Lets say I am selling fruits and giving (selling) certain fruits a barcode range that they can apply to their fruits BCLog (barcode start, barcode finish, product) 100000...

Sorry I thought I replied to this last week sometime! Does this look better? BTTRACKING tracking_id, bt_name, part_number, invoice_code, date_used etc... 11000, B, 1234-ABC-56, 07891, ... 12000, F, 5678-DEF-90, 09999 13000, B, 2233-ABC-4455, 9595 BTSCHEDULING tracking_id, sched_id, sched_date...

Sorry about that, I dont want to overbear with information. Im working with a query A) BTTRACKING tracking_id [number - ex: "12345"] primary key bt_name [string - ex: "BFR"] part_number [string - ex : "15-1551-ABC"] invoice_code [number - ex: "12345"] etc. etc. this table is quite large...

Hello, How would I go about displaying multiple dates on a TOTALS query that also require a WHERE clause? These are some of the fields needed: · Date paid (BT Tracking: BT Request Date) · Date BDI #1 Scheduled (BT Scheduling: Schedule Date) Note: Only use “Status”: Confirmed...